VIEW: APPS.PO_ECX_LINE_LOC_V

Source

View Text - Preformatted

SELECT PLLA.PO_HEADER_ID PO_HEADER_ID, PLLA.PO_RELEASE_ID RELEASE_ID, PLLA.PO_LINE_ID PO_LINE_ID, PLA.LINE_NUM LINE_NUM, PLLA.LINE_LOCATION_ID LINE_LOCATION_ID, PLLA.SHIPMENT_NUM SHIPMENT_NUMBER, (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) ORDERED_QUANTITY, DECODE(PLLA.UNIT_MEAS_LOOKUP_CODE, NULL, PLA.UNIT_MEAS_LOOKUP_CODE, PLLA.UNIT_MEAS_LOOKUP_CODE) UOM, DECODE (PLLA.NEED_BY_DATE, NULL, PLLA.PROMISED_DATE, PLLA.NEED_BY_DATE) NEED_BY_DATE, HOU_V.NAME SHIPTO_ORG_NAME, '0' SHIPTO_ORG_OTF, 'ShipTo' SHIPTO_ORG_PARTNER_TYPE, PLLA.ORG_ID PARTNER_ID, nvl (HLAS.ECE_TP_LOCATION_CODE, PLLA.ORG_ID) PARTNER_ID_X, FSPA.PAYMENT_CURRENCY_CODE BUYING_ORG_CURRENCY, HLAS.ADDRESS_LINE_1 SHIPTO_ORG_ADDR_LINE1, HLAS.ADDRESS_LINE_2 SHIPTO_ORG_ADDR_LINE2, HLAS.ADDRESS_LINE_3 SHIPTO_ORG_ADDR_LINE3, HLAS.TOWN_OR_CITY SHIPTO_ORG_CITY, HLAS.COUNTRY SHIPTO_ORG_COUNTRY, HLAS.POSTAL_CODE SHIPTO_ORG_ZIP, HLAS.REGION_2 SHIPTO_ORG_STATE, HLAS.TELEPHONE_NUMBER_1 SHIPTO_ORG_PHONE1, HLAS.TELEPHONE_NUMBER_2 SHIPTO_ORG_PHONE2, HLAS.TELEPHONE_NUMBER_3 SHIPTO_ORG_PHONE3 FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA, PO_LINES_ALL PLA, FINANCIALS_SYSTEM_PARAMS_ALL FSPA, HR_LOCATIONS_ALL HLAS, HR_ORGANIZATION_UNITS_V HOU_V WHERE PLA.PO_LINE_ID = PLLA.PO_LINE_ID AND PLLA.PO_HEADER_ID = PLA.PO_HEADER_ID AND PLLA.REVISION_NUM = 0 AND (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) > 0 AND FSPA.ORG_ID = PLLA.ORG_ID AND HOU_V.ORGANIZATION_ID = PLLA.ORG_ID AND HLAS.LOCATION_ID = PLLA.SHIP_TO_LOCATION_ID

View Text - HTML Formatted

SELECT PLLA.PO_HEADER_ID PO_HEADER_ID
, PLLA.PO_RELEASE_ID RELEASE_ID
, PLLA.PO_LINE_ID PO_LINE_ID
, PLA.LINE_NUM LINE_NUM
, PLLA.LINE_LOCATION_ID LINE_LOCATION_ID
, PLLA.SHIPMENT_NUM SHIPMENT_NUMBER
, (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) ORDERED_QUANTITY
, DECODE(PLLA.UNIT_MEAS_LOOKUP_CODE
, NULL
, PLA.UNIT_MEAS_LOOKUP_CODE
, PLLA.UNIT_MEAS_LOOKUP_CODE) UOM
, DECODE (PLLA.NEED_BY_DATE
, NULL
, PLLA.PROMISED_DATE
, PLLA.NEED_BY_DATE) NEED_BY_DATE
, HOU_V.NAME SHIPTO_ORG_NAME
, '0' SHIPTO_ORG_OTF
, 'SHIPTO' SHIPTO_ORG_PARTNER_TYPE
, PLLA.ORG_ID PARTNER_ID
, NVL (HLAS.ECE_TP_LOCATION_CODE
, PLLA.ORG_ID) PARTNER_ID_X
, FSPA.PAYMENT_CURRENCY_CODE BUYING_ORG_CURRENCY
, HLAS.ADDRESS_LINE_1 SHIPTO_ORG_ADDR_LINE1
, HLAS.ADDRESS_LINE_2 SHIPTO_ORG_ADDR_LINE2
, HLAS.ADDRESS_LINE_3 SHIPTO_ORG_ADDR_LINE3
, HLAS.TOWN_OR_CITY SHIPTO_ORG_CITY
, HLAS.COUNTRY SHIPTO_ORG_COUNTRY
, HLAS.POSTAL_CODE SHIPTO_ORG_ZIP
, HLAS.REGION_2 SHIPTO_ORG_STATE
, HLAS.TELEPHONE_NUMBER_1 SHIPTO_ORG_PHONE1
, HLAS.TELEPHONE_NUMBER_2 SHIPTO_ORG_PHONE2
, HLAS.TELEPHONE_NUMBER_3 SHIPTO_ORG_PHONE3
FROM PO_LINE_LOCATIONS_ARCHIVE_ALL PLLA
, PO_LINES_ALL PLA
, FINANCIALS_SYSTEM_PARAMS_ALL FSPA
, HR_LOCATIONS_ALL HLAS
, HR_ORGANIZATION_UNITS_V HOU_V
WHERE PLA.PO_LINE_ID = PLLA.PO_LINE_ID
AND PLLA.PO_HEADER_ID = PLA.PO_HEADER_ID
AND PLLA.REVISION_NUM = 0
AND (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) > 0
AND FSPA.ORG_ID = PLLA.ORG_ID
AND HOU_V.ORGANIZATION_ID = PLLA.ORG_ID
AND HLAS.LOCATION_ID = PLLA.SHIP_TO_LOCATION_ID