View: PO_LINE_LOCATIONS_CHANGE_PRINT

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

View Text

SELECT PLL.SHIPMENT_NUM
, PLL.REVISION_NUM
, DECODE(PLL.SHIPMENT_TYPE
, 'PRICE BREAK'
, 'BLANKET'
, 'SCHEDULED'
, 'RELEASE'
, 'BLANKET'
, 'RELEASE'
, 'STANDARD'
, 'STANDARD'
, 'PLANNED'
, 'PLANNED')
, NVL(PLL.PROMISED_DATE
, PLL.NEED_BY_DATE)
, PLL.QUANTITY
, PLL.PRICE_OVERRIDE
, PLL.QUANTITY_CANCELLED
, DECODE(PLL.CANCEL_FLAG
, 'Y'
, 'Y'
, 'I'
, 'Y'
, 'N'
, 'N'
, NULL)
, PLL.CANCEL_DATE
, PLL.CANCEL_REASON
, PLL.TAXABLE_FLAG
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3
, HRL.TOWN_OR_CITY
, NVL( DECODE(HRL.REGION_1
, NULL
, HRL.REGION_2
, DECODE(FCL1.MEANING
, NULL
, DECODE(FCL2.MEANING
, NULL
, FCL3.MEANING
, FCL2.LOOKUP_CODE)
, FCL1.LOOKUP_CODE))
, HRL.REGION_2)
, HRL.POSTAL_CODE
, FTE.TERRITORY_SHORT_NAME
, 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
, PLL.PO_RELEASE_ID
, PLL.AMOUNT
, PLL.AMOUNT_CANCELLED
, PLL.ORG_ID
FROM PO_LINE_LOCATIONS_ARCHIVE PLL
, PO_HR_LOCATIONS HRL
, PO_HEADERS_ALL POH
, FND_TERRITORIES_TL FTE
, FND_LOOKUP_VALUES FCL1
, FND_LOOKUP_VALUES FCL2
, FND_LOOKUP_VALUES FCL3
WHERE HRL.LOCATION_ID (+) = PLL.SHIP_TO_LOCATION_ID
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND NVL(PLL.LATEST_EXTERNAL_FLAG
, 'N') = 'Y'
AND HRL.COUNTRY = FTE.TERRITORY_CODE (+)
AND DECODE(FTE.TERRITORY_CODE
, NULL
, '1'
, FTE.LANGUAGE) = DECODE(FTE.TERRITORY_CODE
, NULL
, '1'
, USERENV('LANG'))
AND HRL.REGION_1 = FCL1.LOOKUP_CODE (+)
AND HRL.COUNTRY || '_PROVINCE' = FCL1.LOOKUP_TYPE (+)
AND DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, FCL1.SECURITY_GROUP_ID) = DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL1.LOOKUP_TYPE
, FCL1.VIEW_APPLICATION_ID))
AND DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, FCL1.VIEW_APPLICATION_ID) = DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, FCL1.LANGUAGE) = DECODE(FCL1.LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG'))
AND HRL.REGION_2 = FCL2.LOOKUP_CODE (+)
AND HRL.COUNTRY || '_STATE' = FCL2.LOOKUP_TYPE (+)
AND DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, FCL2.SECURITY_GROUP_ID) = DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL2.LOOKUP_TYPE
, FCL2.VIEW_APPLICATION_ID))
AND DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, FCL2.VIEW_APPLICATION_ID) = DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, FCL2.LANGUAGE) = DECODE(FCL2.LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG'))
AND HRL.REGION_1 = FCL3.LOOKUP_CODE (+)
AND HRL.COUNTRY || '_COUNTY' = FCL3.LOOKUP_TYPE (+)
AND DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FCL3.SECURITY_GROUP_ID) = DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(FCL3.LOOKUP_TYPE
, FCL3.VIEW_APPLICATION_ID))
AND DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FCL3.VIEW_APPLICATION_ID) = DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, 3)
AND DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, FCL3.LANGUAGE) = DECODE(FCL3.LOOKUP_CODE
, NULL
, '1'
, USERENV('LANG'))

Columns