eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MRP_PO_FLEX_FENCES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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