PO_SUPPLIERS_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
SEGMENT1 VAT_REGISTRATION_NUM TYPE_1099 VENDOR_ID SHIP_TO_LOCATION_ID BILL_TO_LOCATION_ID FOB_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE VAT_CODE

Query

SQL_Statement
SELECT POV.SEGMENT1, POV.VAT_REGISTRATION_NUM, POV.TYPE_1099, POV.VENDOR_ID, NULL SHIP_TO_LOCATION_ID , NULL BILL_TO_LOCATION_ID, NULL FOB_LOOKUP_CODE, NULL FREIGHT_TERMS_LOOKUP_CODE , NULL VAT_CODE FROM POZ_SUPPLIERS POV WHERE POV.ENABLED_FLAG = 'Y' AND SYSDATE BETWEEN NVL(POV.START_DATE_ACTIVE, SYSDATE-1) AND NVL(POV.END_DATE_ACTIVE, SYSDATE+1)