View: JAI_PO_RFQQT_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_PO_RFQQT_V

View Text

SELECT A.PO_HEADER_ID
, A.PO_LINE_ID
, A.LINE_NUM
, A.ITEM_ID
, A.ITEM_DESCRIPTION
, A.UNIT_MEAS_LOOKUP_CODE L_UOM
, A.UNIT_PRICE
, A.QUANTITY L_QTY
, B.LINE_LOCATION_ID
, B.SHIPMENT_NUM
, DECODE( B.UNIT_MEAS_LOOKUP_CODE
, NULL
, A.UNIT_MEAS_LOOKUP_CODE
, B.UNIT_MEAS_LOOKUP_CODE ) LL_UOM
, B.QUANTITY LL_QTY
, B.PRICE_OVERRIDE
, B.SHIP_TO_ORGANIZATION_ID
, B.SHIP_TO_LOCATION_ID
, TO_CHAR(B.NEED_BY_DATE) NEED_BY_DATE
, B.CLOSED_CODE CLOSED_CODE
FROM PO_LINES_ALL A
, PO_LINE_LOCATIONS_ALL B
, PO_HEADERS_ALL C
WHERE A.PO_LINE_ID = B.PO_LINE_ID
AND A.PO_HEADER_ID = C.PO_HEADER_ID
AND B.SHIPMENT_TYPE NOT IN ( 'SCHEDULED'
, 'BLANKET' )
AND ( B.CANCEL_FLAG IS NULL OR B.CANCEL_FLAG = 'N' )
AND (LTRIM(RTRIM(C.TYPE_LOOKUP_CODE)) || '_' || LTRIM(RTRIM(B.SHIPMENT_TYPE)) <> 'BLANKET_PRICE BREAK') UNION ALL SELECT A.PO_HEADER_ID
, A.PO_LINE_ID
, A.LINE_NUM
, A.ITEM_ID
, A.ITEM_DESCRIPTION
, A.UNIT_MEAS_LOOKUP_CODE L_UOM
, A.UNIT_PRICE
, A.QUANTITY L_QTY
, B.LINE_LOCATION_ID
, B.SHIPMENT_NUM
, DECODE( B.UNIT_MEAS_LOOKUP_CODE
, NULL
, A.UNIT_MEAS_LOOKUP_CODE
, B.UNIT_MEAS_LOOKUP_CODE ) LL_UOM
, B.QUANTITY LL_QTY
, B.PRICE_OVERRIDE
, B.SHIP_TO_ORGANIZATION_ID
, B.SHIP_TO_LOCATION_ID
, TO_CHAR(B.NEED_BY_DATE) NEED_BY_DATE
, B.CLOSED_CODE CLOSED_CODE
FROM PO_LINES_ALL A
, PO_LINE_LOCATIONS_ALL B
, PO_HEADERS_ALL C
WHERE A.PO_LINE_ID = B.PO_LINE_ID
AND A.PO_HEADER_ID = C.PO_HEADER_ID
AND (C.TYPE_LOOKUP_CODE = 'BLANKET'
AND B.SHIPMENT_TYPE = 'PRICE BREAK'
AND B.QUANTITY <> 0)
AND ( B.CANCEL_FLAG IS NULL OR B.CANCEL_FLAG = 'N') UNION ALL SELECT PHA.PO_HEADER_ID
, PLA.PO_LINE_ID
, PLA.LINE_NUM
, PLA.ITEM_ID
, PLA.ITEM_DESCRIPTION
, PLA.UNIT_MEAS_LOOKUP_CODE L_UOM
, PLA.UNIT_PRICE
, PLA.QUANTITY L_QTY
, 0
, 0
, NULL
, 0
, 0
, 0
, 0
, NULL
, NULL CLOSED_CODE
FROM PO_HEADERS_ALL PHA
, PO_LINES_ALL PLA
WHERE PHA.PO_HEADER_ID = PLA.PO_HEADER_ID
AND PHA.TYPE_LOOKUP_CODE IN ('BLANKET'
, 'PLANNED'
, 'QUOTATION'
, 'RFQ')

Columns