eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ICX_POR_REQ_ASLS

Source

View Text - Preformatted


SELECT PASL.ASL_ID, PASL.ITEM_ID, PASL.CATEGORY_ID, UOMTL.UOM_CODE UNIT_OF_MEASURE, GSB.CURRENCY_CODE CURRENCY, PV.VENDOR_NAME SUPPLIER, PASL.VENDOR_ID SUPPLIER_ID, PASL.VENDOR_SITE_ID SUPPLIER_SITE_ID, PVS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE, PASL.PRIMARY_VENDOR_ITEM SUPPLIER_PART_NUMBER, PASL.OWNING_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID, FSPA.ORG_ID OPERATING_UNIT_ID, PASL.CREATION_DATE, PASL.LAST_UPDATE_DATE FROM FINANCIALS_SYSTEM_PARAMS_ALL FSPA, PO_ASL_ATTRIBUTES PAA, MTL_UNITS_OF_MEASURE_TL UOMTL, PO_VENDORS PV, PO_VENDOR_SITES_ALL PVS, PO_APPROVED_SUPPLIER_LIST PASL, GL_SETS_OF_BOOKS GSB WHERE PAA.ASL_ID (+) = PASL.ASL_ID AND PAA.PURCHASING_UNIT_OF_MEASURE = UOMTL.UNIT_OF_MEASURE(+) AND EXISTS (SELECT NULL FROM FND_LANGUAGES WHERE INSTALLED_FLAG = 'B' AND NVL(UOMTL.LANGUAGE, LANGUAGE_CODE) = LANGUAGE_CODE) AND FSPA.INVENTORY_ORGANIZATION_ID = PASL.OWNING_ORGANIZATION_ID AND PASL.VENDOR_ID = PV.VENDOR_ID AND PASL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+) AND GSB.SET_OF_BOOKS_ID = FSPA.SET_OF_BOOKS_ID

View Text - HTML Formatted

SELECT PASL.ASL_ID
, PASL.ITEM_ID
, PASL.CATEGORY_ID
, UOMTL.UOM_CODE UNIT_OF_MEASURE
, GSB.CURRENCY_CODE CURRENCY
, PV.VENDOR_NAME SUPPLIER
, PASL.VENDOR_ID SUPPLIER_ID
, PASL.VENDOR_SITE_ID SUPPLIER_SITE_ID
, PVS.VENDOR_SITE_CODE SUPPLIER_SITE_CODE
, PASL.PRIMARY_VENDOR_ITEM SUPPLIER_PART_NUMBER
, PASL.OWNING_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
, FSPA.ORG_ID OPERATING_UNIT_ID
, PASL.CREATION_DATE
, PASL.LAST_UPDATE_DATE
FROM FINANCIALS_SYSTEM_PARAMS_ALL FSPA
, PO_ASL_ATTRIBUTES PAA
, MTL_UNITS_OF_MEASURE_TL UOMTL
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL PVS
, PO_APPROVED_SUPPLIER_LIST PASL
, GL_SETS_OF_BOOKS GSB
WHERE PAA.ASL_ID (+) = PASL.ASL_ID
AND PAA.PURCHASING_UNIT_OF_MEASURE = UOMTL.UNIT_OF_MEASURE(+)
AND EXISTS (SELECT NULL
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG = 'B'
AND NVL(UOMTL.LANGUAGE
, LANGUAGE_CODE) = LANGUAGE_CODE)
AND FSPA.INVENTORY_ORGANIZATION_ID = PASL.OWNING_ORGANIZATION_ID
AND PASL.VENDOR_ID = PV.VENDOR_ID
AND PASL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID (+)
AND GSB.SET_OF_BOOKS_ID = FSPA.SET_OF_BOOKS_ID