View: ICX_POR_REQ_ASLS

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.ICX_POR_REQ_ASLS

View Text

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

Columns