VIEW: APPS.CLN_PO_ECX_LINE_LOC_ARCH_V

Source

View Text - Preformatted

SELECT PLLA.SUPPLIER_ORDER_LINE_NUMBER, PLLA.PO_HEADER_ID PO_HEADER_ID, PLLA.PO_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_NUM, (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) ORDERED_QUANTITY, MUOMTL.UOM_CODE UOM, PLLA.NEED_BY_DATE NEED_BY_DATE, PLLA.ORG_ID PARTNER_ID, PLLA.PROMISED_DATE PROMISED_DATE, PLLA.LAST_ACCEPT_DATE LAST_ACCEPT_DATE, PLLA.PRICE_OVERRIDE PRICE_OVERRIDE, PLLA.TAXABLE_FLAG TAXABLE_FLAG, PLLA.TAX_CODE_ID TAX_CODE_ID, PLLA.SHIP_TO_LOCATION_ID, NVL(PLLA.CONSIGNED_FLAG,'N') FROM PO_LINE_LOCATIONS_ALL PLLA, PO_LINES_ALL PLA, MTL_UNITS_OF_MEASURE_TL MUOMTL WHERE PLA.PO_LINE_ID = PLLA.PO_LINE_ID AND PLLA.PO_HEADER_ID = PLA.PO_HEADER_ID AND (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) > 0 AND DECODE(PLLA.UNIT_MEAS_LOOKUP_CODE, NULL, PLA.UNIT_MEAS_LOOKUP_CODE, PLLA.UNIT_MEAS_LOOKUP_CODE) = MUOMTL.UNIT_OF_MEASURE AND MUOMTL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT PLLA.SUPPLIER_ORDER_LINE_NUMBER
, PLLA.PO_HEADER_ID PO_HEADER_ID
, PLLA.PO_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_NUM
, (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) ORDERED_QUANTITY
, MUOMTL.UOM_CODE UOM
, PLLA.NEED_BY_DATE NEED_BY_DATE
, PLLA.ORG_ID PARTNER_ID
, PLLA.PROMISED_DATE PROMISED_DATE
, PLLA.LAST_ACCEPT_DATE LAST_ACCEPT_DATE
, PLLA.PRICE_OVERRIDE PRICE_OVERRIDE
, PLLA.TAXABLE_FLAG TAXABLE_FLAG
, PLLA.TAX_CODE_ID TAX_CODE_ID
, PLLA.SHIP_TO_LOCATION_ID
, NVL(PLLA.CONSIGNED_FLAG
, 'N')
FROM PO_LINE_LOCATIONS_ALL PLLA
, PO_LINES_ALL PLA
, MTL_UNITS_OF_MEASURE_TL MUOMTL
WHERE PLA.PO_LINE_ID = PLLA.PO_LINE_ID
AND PLLA.PO_HEADER_ID = PLA.PO_HEADER_ID
AND (PLLA.QUANTITY - PLLA.QUANTITY_CANCELLED) > 0
AND DECODE(PLLA.UNIT_MEAS_LOOKUP_CODE
, NULL
, PLA.UNIT_MEAS_LOOKUP_CODE
, PLLA.UNIT_MEAS_LOOKUP_CODE) = MUOMTL.UNIT_OF_MEASURE
AND MUOMTL.LANGUAGE = USERENV('LANG')