VIEW: APPS.PO_LINE_LOCATIONS_CHANGE_PRINT

Source

View Text - Preformatted

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

View Text - HTML Formatted

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