VIEW: APPS.PO_SUPPLIER_SITES_VAL_V

Source

View Text - Preformatted

SELECT VENDOR_SITE_CODE , ADDRESS_LINE1 , CITY , STATE , VENDOR_SITE_ID , VENDOR_ID , SHIP_TO_LOCATION_ID , BILL_TO_LOCATION_ID , SHIP_VIA_LOOKUP_CODE , FOB_LOOKUP_CODE , FREIGHT_TERMS_LOOKUP_CODE , ADDRESS_LINE2 , ADDRESS_LINE3 , ZIP , COUNTRY , '('||AREA_CODE||') '||PHONE TELEPHONE , '('||FAX_AREA_CODE||') '||FAX FAX , INVOICE_CURRENCY_CODE , RFQ_ONLY_SITE_FLAG , PCARD_SITE_FLAG , VENDOR_SITE_CODE || ' - ' || PO_MOAC_UTILS_PVT.GET_OU_NAME(ORG_ID) VENDOR_SITE_CODE_OU , ORG_ID , ADDRESS_LINE4 , PROVINCE FROM PO_VENDOR_SITES WHERE (PURCHASING_SITE_FLAG = 'Y' or RFQ_ONLY_SITE_FLAG = 'Y') AND SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1)

View Text - HTML Formatted

SELECT VENDOR_SITE_CODE
, ADDRESS_LINE1
, CITY
, STATE
, VENDOR_SITE_ID
, VENDOR_ID
, SHIP_TO_LOCATION_ID
, BILL_TO_LOCATION_ID
, SHIP_VIA_LOOKUP_CODE
, FOB_LOOKUP_CODE
, FREIGHT_TERMS_LOOKUP_CODE
, ADDRESS_LINE2
, ADDRESS_LINE3
, ZIP
, COUNTRY
, '('||AREA_CODE||') '||PHONE TELEPHONE
, '('||FAX_AREA_CODE||') '||FAX FAX
, INVOICE_CURRENCY_CODE
, RFQ_ONLY_SITE_FLAG
, PCARD_SITE_FLAG
, VENDOR_SITE_CODE || ' - ' || PO_MOAC_UTILS_PVT.GET_OU_NAME(ORG_ID) VENDOR_SITE_CODE_OU
, ORG_ID
, ADDRESS_LINE4
, PROVINCE
FROM PO_VENDOR_SITES
WHERE (PURCHASING_SITE_FLAG = 'Y' OR RFQ_ONLY_SITE_FLAG = 'Y')
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)