PJC_XLA_SUPPLIERS_REF_V

Details

• Schema: FUSION

• Object owner: PJC

• Object type: VIEW

Columns

Name
VENDOR_ID VENDOR_NAME VENDOR_NUMBER VENDOR_ALT_NAME

Query

SQL_Statement
select VENDOR_ID VENDOR_ID, VENDOR_NAME VENDOR_NAME, SEGMENT1 VENDOR_NUMBER, VENDOR_NAME_ALT VENDOR_ALT_NAME from POZ_SUPPLIERS_V where ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE,TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE, TRUNC(SYSDATE))