VIEW: APPS.POBV_BKT_PO_LINE_PRICE_BREAKS

Source

View Text - Preformatted

SELECT ps.LINE_LOCATION_ID, ps.SHIPMENT_NUM, ps.PO_LINE_ID, pl.LINE_NUM, ps.PO_HEADER_ID, ph.SEGMENT1, ps.ORG_ID, op.NAME, ps.APPROVED_DATE, '_LA:ps.APPROVED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', ps.QUANTITY, ps.PRICE_OVERRIDE, ps.PRICE_DISCOUNT, ps.SHIP_TO_LOCATION_ID, ps.SHIP_TO_ORGANIZATION_ID, ps.CREATION_DATE, ps.CREATED_BY, ps.LAST_UPDATE_DATE, ps.LAST_UPDATED_BY, ps.VALUE_BASIS, ps.MATCHING_BASIS, ps.PAYMENT_TYPE, ps.DESCRIPTION, ps.WORK_APPROVER_ID, ps.BID_PAYMENT_ID, ps.QUANTITY_FINANCED, ps.AMOUNT_FINANCED, ps.QUANTITY_RECOUPED, ps.AMOUNT_RECOUPED, ps.RETAINAGE_WITHHELD_AMOUNT, ps.RETAINAGE_RELEASED_AMOUNT, ps.OUTSOURCED_ASSEMBLY, ps.TAX_ATTRIBUTE_UPDATE_CODE, ps.ORIGINAL_SHIPMENT_ID FROM PO_LINE_LOCATIONS_ALL PS, PO_LINES_ALL PL, PO_HEADERS_ALL PH, HR_ALL_ORGANIZATION_UNITS OP WHERE PH.TYPE_LOOKUP_CODE = 'BLANKET' AND PS.SHIPMENT_TYPE = 'PRICE BREAK' AND PS.PO_LINE_ID = PL.PO_LINE_ID AND PS.PO_HEADER_ID = PH.PO_HEADER_ID AND PS.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PS.LINE_LOCATION_ID
, PS.SHIPMENT_NUM
, PS.PO_LINE_ID
, PL.LINE_NUM
, PS.PO_HEADER_ID
, PH.SEGMENT1
, PS.ORG_ID
, OP.NAME
, PS.APPROVED_DATE
, '_LA:PS.APPROVED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PS.QUANTITY
, PS.PRICE_OVERRIDE
, PS.PRICE_DISCOUNT
, PS.SHIP_TO_LOCATION_ID
, PS.SHIP_TO_ORGANIZATION_ID
, PS.CREATION_DATE
, PS.CREATED_BY
, PS.LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY
, PS.VALUE_BASIS
, PS.MATCHING_BASIS
, PS.PAYMENT_TYPE
, PS.DESCRIPTION
, PS.WORK_APPROVER_ID
, PS.BID_PAYMENT_ID
, PS.QUANTITY_FINANCED
, PS.AMOUNT_FINANCED
, PS.QUANTITY_RECOUPED
, PS.AMOUNT_RECOUPED
, PS.RETAINAGE_WITHHELD_AMOUNT
, PS.RETAINAGE_RELEASED_AMOUNT
, PS.OUTSOURCED_ASSEMBLY
, PS.TAX_ATTRIBUTE_UPDATE_CODE
, PS.ORIGINAL_SHIPMENT_ID
FROM PO_LINE_LOCATIONS_ALL PS
, PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PH.TYPE_LOOKUP_CODE = 'BLANKET'
AND PS.SHIPMENT_TYPE = 'PRICE BREAK'
AND PS.PO_LINE_ID = PL.PO_LINE_ID
AND PS.PO_HEADER_ID = PH.PO_HEADER_ID
AND PS.ORG_ID = OP.ORGANIZATION_ID WITH READ ONLY