FND Design Data [Home] [Help]

View: PO_APPROVED_SUPPLIER_LIS_VAL_V

Product: PO - Purchasing
Description: PO_ASL_V view displays only enabled ASL's.
Implementation/DBA Data: ViewAPPS.PO_APPROVED_SUPPLIER_LIS_VAL_V
View Text

SELECT ASL_ID
, USING_ORGANIZATION_ID
, OWNING_ORGANIZATION_ID
, VENDOR_BUSINESS_TYPE
, ASL_STATUS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, MANUFACTURER_ID
, VENDOR_ID
, ITEM_ID
, CATEGORY_ID
, VENDOR_SITE_ID
, PRIMARY_VENDOR_ITEM
, MANUFACTURER_ASL_ID
, REVIEW_BY_DATE
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM PO_APPROVED_SUPPLIER_LIST
WHERE NVL(DISABLE_FLAG
, 'N') = 'N'

Columns

Name
ASL_ID
USING_ORGANIZATION_ID
OWNING_ORGANIZATION_ID
VENDOR_BUSINESS_TYPE
ASL_STATUS_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
MANUFACTURER_ID
VENDOR_ID
ITEM_ID
CATEGORY_ID
VENDOR_SITE_ID
PRIMARY_VENDOR_ITEM
MANUFACTURER_ASL_ID
REVIEW_BY_DATE
COMMENTS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE