VIEW: APPS.MRP_PO_SUPPLIERS_V

Source

View Text - Preformatted

SELECT DISTINCT items.compile_designator, items.inventory_item_id, mpo.organization_id, asl.using_organization_id, po.asl_id, po.vendor_id, po.vendor_site_id, po.processing_lead_time, po.min_order_qty, po.fixed_lot_multiple, po.delivery_calendar, po.purchasing_unit_of_measure, po.purchasing_unit_of_measure from po_approved_supplier_lis_val_v asl, po_asl_attributes po, mrp_system_items items, mrp_plan_organizations_v mpo WHERE asl.item_id = items.inventory_item_id and asl.using_organization_id = -1 and po.asl_id = asl.asl_id and po.using_organization_id = asl.using_organization_id and items.compile_designator = mpo.compile_designator and items.organization_id = mpo.planned_organization and po_asl_sv.check_asl_action('2_SOURCING', po.vendor_id, po.vendor_site_id, items.inventory_item_id, NULL, NULL) != 0

View Text - HTML Formatted

SELECT DISTINCT ITEMS.COMPILE_DESIGNATOR
, ITEMS.INVENTORY_ITEM_ID
, MPO.ORGANIZATION_ID
, ASL.USING_ORGANIZATION_ID
, PO.ASL_ID
, PO.VENDOR_ID
, PO.VENDOR_SITE_ID
, PO.PROCESSING_LEAD_TIME
, PO.MIN_ORDER_QTY
, PO.FIXED_LOT_MULTIPLE
, PO.DELIVERY_CALENDAR
, PO.PURCHASING_UNIT_OF_MEASURE
, PO.PURCHASING_UNIT_OF_MEASURE
FROM PO_APPROVED_SUPPLIER_LIS_VAL_V ASL
, PO_ASL_ATTRIBUTES PO
, MRP_SYSTEM_ITEMS ITEMS
, MRP_PLAN_ORGANIZATIONS_V MPO
WHERE ASL.ITEM_ID = ITEMS.INVENTORY_ITEM_ID
AND ASL.USING_ORGANIZATION_ID = -1
AND PO.ASL_ID = ASL.ASL_ID
AND PO.USING_ORGANIZATION_ID = ASL.USING_ORGANIZATION_ID
AND ITEMS.COMPILE_DESIGNATOR = MPO.COMPILE_DESIGNATOR
AND ITEMS.ORGANIZATION_ID = MPO.PLANNED_ORGANIZATION
AND PO_ASL_SV.CHECK_ASL_ACTION('2_SOURCING'
, PO.VENDOR_ID
, PO.VENDOR_SITE_ID
, ITEMS.INVENTORY_ITEM_ID
, NULL
, NULL) != 0