View: MRP_PO_FLEX_FENCES_V

Product:	MRP - Master Scheduling/MRP
Description:	Purchasing flex fences view
Implementation/DBA Data:	APPS.MRP_PO_FLEX_FENCES_V

View Text

SELECT DISTINCT SUP.COMPILE_DESIGNATOR
, SUP.INVENTORY_ITEM_ID
, SUP.ORGANIZATION_ID
, SUP.USING_ORGANIZATION_ID
, SUP.SUPPLIER_ID
, SUP.SUPPLIER_SITE_ID
, FENCE.NUMBER_OF_DAYS
, FENCE.TOLERANCE
FROM PO_SUPPLIER_ITEM_TOLERANCE FENCE
, MRP_PO_SUPPLIERS_V SUP
WHERE FENCE.ASL_ID = SUP.ASL_ID
AND FENCE.USING_ORGANIZATION_ID = SUP.USING_ORGANIZATION_ID

Columns