View: PO_ASL_SUPPLIERS_V

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

View Text

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

Columns