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.PO_ASL_SUPPLIERS_V

Source

View Text - Preformatted


SELECT PASL.ROWID , PASL.ASL_ID , PLC.DISPLAYED_FIELD , DECODE(PASL.VENDOR_BUSINESS_TYPE, 'MANUFACTURER', MM.MANUFACTURER_NAME, PV.VENDOR_NAME) , PVS.VENDOR_SITE_CODE , PASL.PRIMARY_VENDOR_ITEM , PASL.REVIEW_BY_DATE , MP.ORGANIZATION_CODE , HOUT.NAME , MP1.ORGANIZATION_CODE , HOUT1.NAME , DECODE(PASL.USING_ORGANIZATION_ID, -1, 'Y','N') , PAST.STATUS , PASL.ITEM_ID , PASL.CATEGORY_ID , PASL.VENDOR_ID , PASL.MANUFACTURER_ID , PASL.VENDOR_SITE_ID , PASL.MANUFACTURER_ASL_ID , MM1.MANUFACTURER_NAME , PASL.OWNING_ORGANIZATION_ID , PASL.USING_ORGANIZATION_ID , PASL.ASL_STATUS_ID , PASL.VENDOR_BUSINESS_TYPE , PASL.COMMENTS , PASL.ATTRIBUTE_CATEGORY , PASL.ATTRIBUTE1 , PASL.ATTRIBUTE2 , PASL.ATTRIBUTE3 , PASL.ATTRIBUTE4 , PASL.ATTRIBUTE5 , PASL.ATTRIBUTE6 , PASL.ATTRIBUTE7 , PASL.ATTRIBUTE8 , PASL.ATTRIBUTE9 , PASL.ATTRIBUTE10 , PASL.ATTRIBUTE11 , PASL.ATTRIBUTE12 , PASL.ATTRIBUTE13 , PASL.ATTRIBUTE14 , PASL.ATTRIBUTE15 , PASL.LAST_UPDATE_LOGIN , PASL.REQUEST_ID , PASL.PROGRAM_APPLICATION_ID , PASL.PROGRAM_ID , PASL.PROGRAM_UPDATE_DATE , PASL.LAST_UPDATE_DATE , PASL.LAST_UPDATED_BY , PASL.CREATION_DATE , PASL.CREATED_BY , PASL.DISABLE_FLAG , PVS.ORG_ID FROM PO_LOOKUP_CODES PLC , HR_ORG_UNITS_NO_JOIN HOU , HR_ORG_UNITS_NO_JOIN HOU1 , HR_ALL_ORGANIZATION_UNITS_TL HOUT , HR_ALL_ORGANIZATION_UNITS_TL HOUT1 , PO_VENDORS PV , PO_VENDOR_SITES PVS , MTL_MANUFACTURERS MM , MTL_MANUFACTURERS MM1 , MTL_PARAMETERS MP , MTL_PARAMETERS MP1 , PO_ASL_STATUSES PAST , PO_APPROVED_SUPPLIER_LIST PASL1 , PO_ASL_ATTRIBUTES PAA , PO_APPROVED_SUPPLIER_LIST PASL WHERE PASL.VENDOR_BUSINESS_TYPE = PLC.LOOKUP_CODE AND PLC.LOOKUP_TYPE = 'ASL_VENDOR_BUSINESS_TYPE' AND PASL.ASL_STATUS_ID = PAST.STATUS_ID AND PASL.OWNING_ORGANIZATION_ID = MP.ORGANIZATION_ID AND PASL.USING_ORGANIZATION_ID = MP1.ORGANIZATION_ID(+) AND PASL.OWNING_ORGANIZATION_ID = HOU.ORGANIZATION_ID AND PASL.USING_ORGANIZATION_ID = HOU1.ORGANIZATION_ID(+) AND PASL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+) AND ((PASL.VENDOR_SITE_ID IS NOT NULL AND PVS.VENDOR_SITE_CODE IS NOT NULL) OR (PASL.VENDOR_SITE_ID IS NULL AND PVS.VENDOR_SITE_CODE IS NULL)) AND PASL.VENDOR_ID = PV.VENDOR_ID(+) AND PASL.MANUFACTURER_ID = MM.MANUFACTURER_ID(+) AND PASL.MANUFACTURER_ASL_ID = PASL1.ASL_ID(+) AND PASL1.MANUFACTURER_ID = MM1.MANUFACTURER_ID(+) AND PASL.ASL_ID = PAA.ASL_ID AND PASL.USING_ORGANIZATION_ID = PAA.USING_ORGANIZATION_ID AND hou.organization_id = hout.organization_id (+) AND DECODE(hout.organization_id, null, '1', hout.language) = DECODE(hout.organization_id, null, '1', USERENV('LANG')) AND hou1.organization_id = hout1.organization_id (+) AND DECODE(hout1.organization_id, null, '1', hout1.language) = DECODE(hout1.organization_id, null, '1', USERENV('LANG'))

View Text - HTML Formatted

SELECT PASL.ROWID
, PASL.ASL_ID
, PLC.DISPLAYED_FIELD
, DECODE(PASL.VENDOR_BUSINESS_TYPE
, 'MANUFACTURER'
, MM.MANUFACTURER_NAME
, PV.VENDOR_NAME)
, PVS.VENDOR_SITE_CODE
, PASL.PRIMARY_VENDOR_ITEM
, PASL.REVIEW_BY_DATE
, MP.ORGANIZATION_CODE
, HOUT.NAME
, MP1.ORGANIZATION_CODE
, HOUT1.NAME
, DECODE(PASL.USING_ORGANIZATION_ID
, -1
, 'Y'
, 'N')
, PAST.STATUS
, PASL.ITEM_ID
, PASL.CATEGORY_ID
, PASL.VENDOR_ID
, PASL.MANUFACTURER_ID
, PASL.VENDOR_SITE_ID
, PASL.MANUFACTURER_ASL_ID
, MM1.MANUFACTURER_NAME
, PASL.OWNING_ORGANIZATION_ID
, PASL.USING_ORGANIZATION_ID
, PASL.ASL_STATUS_ID
, PASL.VENDOR_BUSINESS_TYPE
, PASL.COMMENTS
, PASL.ATTRIBUTE_CATEGORY
, PASL.ATTRIBUTE1
, PASL.ATTRIBUTE2
, PASL.ATTRIBUTE3
, PASL.ATTRIBUTE4
, PASL.ATTRIBUTE5
, PASL.ATTRIBUTE6
, PASL.ATTRIBUTE7
, PASL.ATTRIBUTE8
, PASL.ATTRIBUTE9
, PASL.ATTRIBUTE10
, PASL.ATTRIBUTE11
, PASL.ATTRIBUTE12
, PASL.ATTRIBUTE13
, PASL.ATTRIBUTE14
, PASL.ATTRIBUTE15
, PASL.LAST_UPDATE_LOGIN
, PASL.REQUEST_ID
, PASL.PROGRAM_APPLICATION_ID
, PASL.PROGRAM_ID
, PASL.PROGRAM_UPDATE_DATE
, PASL.LAST_UPDATE_DATE
, PASL.LAST_UPDATED_BY
, PASL.CREATION_DATE
, PASL.CREATED_BY
, PASL.DISABLE_FLAG
, PVS.ORG_ID
FROM PO_LOOKUP_CODES PLC
, HR_ORG_UNITS_NO_JOIN HOU
, HR_ORG_UNITS_NO_JOIN HOU1
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
, HR_ALL_ORGANIZATION_UNITS_TL HOUT1
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
, MTL_MANUFACTURERS MM
, MTL_MANUFACTURERS MM1
, MTL_PARAMETERS MP
, MTL_PARAMETERS MP1
, PO_ASL_STATUSES PAST
, PO_APPROVED_SUPPLIER_LIST PASL1
, PO_ASL_ATTRIBUTES PAA
, PO_APPROVED_SUPPLIER_LIST PASL
WHERE PASL.VENDOR_BUSINESS_TYPE = PLC.LOOKUP_CODE
AND PLC.LOOKUP_TYPE = 'ASL_VENDOR_BUSINESS_TYPE'
AND PASL.ASL_STATUS_ID = PAST.STATUS_ID
AND PASL.OWNING_ORGANIZATION_ID = MP.ORGANIZATION_ID
AND PASL.USING_ORGANIZATION_ID = MP1.ORGANIZATION_ID(+)
AND PASL.OWNING_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND PASL.USING_ORGANIZATION_ID = HOU1.ORGANIZATION_ID(+)
AND PASL.VENDOR_SITE_ID = PVS.VENDOR_SITE_ID(+)
AND ((PASL.VENDOR_SITE_ID IS NOT NULL
AND PVS.VENDOR_SITE_CODE IS NOT NULL) OR (PASL.VENDOR_SITE_ID IS NULL
AND PVS.VENDOR_SITE_CODE IS NULL))
AND PASL.VENDOR_ID = PV.VENDOR_ID(+)
AND PASL.MANUFACTURER_ID = MM.MANUFACTURER_ID(+)
AND PASL.MANUFACTURER_ASL_ID = PASL1.ASL_ID(+)
AND PASL1.MANUFACTURER_ID = MM1.MANUFACTURER_ID(+)
AND PASL.ASL_ID = PAA.ASL_ID
AND PASL.USING_ORGANIZATION_ID = PAA.USING_ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = HOUT.ORGANIZATION_ID (+)
AND DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, HOUT.LANGUAGE) = DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND HOU1.ORGANIZATION_ID = HOUT1.ORGANIZATION_ID (+)
AND DECODE(HOUT1.ORGANIZATION_ID
, NULL
, '1'
, HOUT1.LANGUAGE) = DECODE(HOUT1.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))