VIEW: APPS.PO_LINE_LOCATIONS_PRINT

Source

View Text - Preformatted

SELECT PLL.SHIPMENT_NUM, NVL(PLL.NEED_BY_DATE, PLL.PROMISED_DATE), PLL.QUANTITY, PLL.PRICE_OVERRIDE, PLL.QUANTITY_CANCELLED, PLL.CANCEL_FLAG, PLL.CANCEL_DATE, PLL.CANCEL_REASON, PLL.TAXABLE_FLAG, PLL.START_DATE, PLL.END_DATE, PLL.ATTRIBUTE_CATEGORY, PLL.ATTRIBUTE1, PLL.ATTRIBUTE2, PLL.ATTRIBUTE3, PLL.ATTRIBUTE4, PLL.ATTRIBUTE5, PLL.ATTRIBUTE6, PLL.ATTRIBUTE7, PLL.ATTRIBUTE8, PLL.ATTRIBUTE9, PLL.ATTRIBUTE10, PLL.ATTRIBUTE11, PLL.ATTRIBUTE12, PLL.ATTRIBUTE13, PLL.ATTRIBUTE14, PLL.ATTRIBUTE15, PLL.PO_HEADER_ID, PLL.PO_LINE_ID, PLL.LINE_LOCATION_ID, PLL.SHIP_TO_LOCATION_ID, DECODE(PLL.SHIPMENT_TYPE, 'PRICE BREAK','BLANKET', 'SCHEDULED', 'RELEASE', 'BLANKET','RELEASE', 'STANDARD','STANDARD', 'PLANNED', 'PLANNED'), PLL.PO_RELEASE_ID, PLL.CONSIGNED_FLAG, PLL.AMOUNT, PLL.AMOUNT_CANCELLED, PLL.PROMISED_DATE, PLL.NEED_BY_DATE , PLL.ORG_ID FROM PO_LINE_LOCATIONS_ALL PLL, PO_HEADERS PH WHERE PLL.PO_HEADER_ID = PH.PO_HEADER_ID

View Text - HTML Formatted

SELECT PLL.SHIPMENT_NUM
, NVL(PLL.NEED_BY_DATE
, PLL.PROMISED_DATE)
, PLL.QUANTITY
, PLL.PRICE_OVERRIDE
, PLL.QUANTITY_CANCELLED
, PLL.CANCEL_FLAG
, PLL.CANCEL_DATE
, PLL.CANCEL_REASON
, PLL.TAXABLE_FLAG
, PLL.START_DATE
, PLL.END_DATE
, PLL.ATTRIBUTE_CATEGORY
, PLL.ATTRIBUTE1
, PLL.ATTRIBUTE2
, PLL.ATTRIBUTE3
, PLL.ATTRIBUTE4
, PLL.ATTRIBUTE5
, PLL.ATTRIBUTE6
, PLL.ATTRIBUTE7
, PLL.ATTRIBUTE8
, PLL.ATTRIBUTE9
, PLL.ATTRIBUTE10
, PLL.ATTRIBUTE11
, PLL.ATTRIBUTE12
, PLL.ATTRIBUTE13
, PLL.ATTRIBUTE14
, PLL.ATTRIBUTE15
, PLL.PO_HEADER_ID
, PLL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIP_TO_LOCATION_ID
, DECODE(PLL.SHIPMENT_TYPE
, 'PRICE BREAK'
, 'BLANKET'
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'STANDARD'
, 'STANDARD'
, 'PLANNED'
, 'PLANNED')
, PLL.PO_RELEASE_ID
, PLL.CONSIGNED_FLAG
, PLL.AMOUNT
, PLL.AMOUNT_CANCELLED
, PLL.PROMISED_DATE
, PLL.NEED_BY_DATE
, PLL.ORG_ID
FROM PO_LINE_LOCATIONS_ALL PLL
, PO_HEADERS PH
WHERE PLL.PO_HEADER_ID = PH.PO_HEADER_ID