VIEW: APPS.JAI_PO_RFQQT_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')