PO_SUPPLIER_PO_SITES_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name
VENDOR_SITE_CODE ADDRESS_LINE1 CITY STATE VENDOR_SITE_ID VENDOR_ID SHIP_TO_LOCATION_ID BILL_TO_LOCATION_ID CARRIER_ID FOB_LOOKUP_CODE FREIGHT_TERMS_LOOKUP_CODE ADDRESS_LINE2 ADDRESS_LINE3 ZIP COUNTRY TELEPHONE FAX PRC_BU_ID

Query

SQL_Statement

SELECT VENDOR_SITE_CODE, null ADDRESS_LINE1, null CITY, null STATE, VENDOR_SITE_ID, VENDOR_ID, null SHIP_TO_LOCATION_ID, null BILL_TO_LOCATION_ID, CARRIER_ID, FOB_LOOKUP_CODE, FREIGHT_TERMS_LOOKUP_CODE, null ADDRESS_LINE2, null ADDRESS_LINE3, null ZIP, null COUNTRY, '('||AREA_CODE||') '||PHONE TELEPHONE, '('||FAX_AREA_CODE||') '||FAX FAX, PRC_BU_ID FROM POZ_SUPPLIER_SITES_ALL_X WHERE PURCHASING_SITE_FLAG = 'Y' AND NVL(RFQ_ONLY_SITE_FLAG,'N') != 'Y'