View: MRP_PO_SUPPLIERS_V

Product:	MRP - Master Scheduling/MRP
Description:	Supplier item view
Implementation/DBA Data:	APPS.MRP_PO_SUPPLIERS_V

View Text

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

Columns