VIEW: APPS.POBV_APPROVED_SUPPLIER_LISTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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