View: POBV_BKT_PO_LINE_PRICE_BREAKS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_BKT_PO_LINE_PRICE_BREAKS

View Text

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
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
AND '_SEC:PS.ORG_ID' IS NOT NULL WITH READ ONLY

Columns