View: POBV_APPROVED_SUPPLIER_LISTS

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

View Text

SELECT AL.ASL_ID
, AL.USING_ORGANIZATION_ID
, ST.STATUS
, ST.STATUS_DESCRIPTION
, AL.COMMENTS
, AL.REVIEW_BY_DATE
, '_LA:AL.VENDOR_BUSINESS_TYPE:PO_LOOKUP_CODES:ASL_VENDOR_BUSINESS_TYPE:DISPLAYED_FIELD'
, AL.PRIMARY_VENDOR_ITEM
, '_LA:AT.DOCUMENT_SOURCING_METHOD:PO_LOOKUP_CODES:DOCUMENT_SOURCING_METHOD:DISPLAYED_FIELD'
, '_LA:AT.RELEASE_GENERATION_METHOD:PO_LOOKUP_CODES:DOC GENERATION METHOD:DISPLAYED_FIELD'
, '_LA:AT.ENABLE_PLAN_SCHEDULE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:AT.ENABLE_SHIP_SCHEDULE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:AT.ENABLE_AUTOSCHEDULE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:AT.PLAN_SCHEDULE_TYPE:PO_LOOKUP_CODES:PLAN_SCHEDULE_SUBTYPE:DISPLAYED_FIELD'
, '_LA:AT.SHIP_SCHEDULE_TYPE:PO_LOOKUP_CODES:SHIP_SCHEDULE_SUBTYPE:DISPLAYED_FIELD'
, AL.OWNING_ORGANIZATION_ID
, AL.MANUFACTURER_ID
, AL.VENDOR_ID
, AL.VENDOR_SITE_ID
, AL.ITEM_ID
, AL.CATEGORY_ID
, AL.MANUFACTURER_ASL_ID
, AT.PURCHASING_UNIT_OF_MEASURE
, AT.SCHEDULER_ID
, AL.CREATION_DATE
, AL.CREATED_BY
, AL.LAST_UPDATE_DATE
, AL.LAST_UPDATED_BY
, AT.PRICE_UPDATE_TOLERANCE
, AT.PROCESSING_LEAD_TIME
, AT.MIN_ORDER_QTY
, AT.DELIVERY_CALENDAR
, AT.COUNTRY_OF_ORIGIN_CODE
, '_LA:AT.ENABLE_VMI_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, AT.VMI_MIN_QTY
, AT.VMI_MAX_QTY
, '_LA:AT.ENABLE_VMI_AUTO_REPLENISH_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, AT.VMI_REPLENISHMENT_APPROVAL
, '_LA:AT.CONSIGNED_FROM_SUPPLIER_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, AT.LAST_BILLING_DATE
, AT.CONSIGNED_BILLING_CYCLE
FROM PO_APPROVED_SUPPLIER_LIST AL
, PO_ASL_STATUSES ST
, PO_ASL_ATTRIBUTES AT
WHERE AL.ASL_ID = AT.ASL_ID
AND AL.ASL_STATUS_ID = ST.STATUS_ID
AND AL.USING_ORGANIZATION_ID = AT.USING_ORGANIZATION_ID WITH READ ONLY

Columns