PO_SUPPLIER_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 INVOICE_CURRENCY_CODE RFQ_ONLY_SITE_FLAG PCARD_SITE_FLAG VENDOR_SITE_CODE_OU PRC_BU_ID ADDRESS_LINE4 PROVINCE |
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, INVOICE_CURRENCY_CODE, RFQ_ONLY_SITE_FLAG, PCARD_SITE_FLAG, null VENDOR_SITE_CODE_OU, PRC_BU_ID, null ADDRESS_LINE4, null PROVINCE FROM POZ_SUPPLIER_SITES_ALL_X WHERE (PURCHASING_SITE_FLAG = 'Y' OR RFQ_ONLY_SITE_FLAG = 'Y') |