PO_APPROVED_SUPPLIER_LIS_VAL_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

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 JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Query

SQL_Statement

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 , JOB_DEFINITION_NAME, JOB_DEFINITION_PACKAGE FROM PO_APPROVED_SUPPLIER_LIST WHERE NVL(DISABLE_FLAG, 'N') = 'N'