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_SUPPLIER_CAPACITY_V

Source

View Text - Preformatted


SELECT distinct sup.compile_designator, sup.inventory_item_id, sup.organization_id, cap.using_organization_id, sup.supplier_id, sup.supplier_site_id, cap.from_date, cap.to_date, cap.capacity_per_day from po_supplier_item_capacity cap, mrp_po_suppliers_v sup WHERE cap.asl_id = sup.asl_id and cap.using_organization_id = sup.using_organization_id and trunc(nvl(cap.to_date,sysdate+1)) >= trunc(sysdate)

View Text - HTML Formatted

SELECT DISTINCT SUP.COMPILE_DESIGNATOR
, SUP.INVENTORY_ITEM_ID
, SUP.ORGANIZATION_ID
, CAP.USING_ORGANIZATION_ID
, SUP.SUPPLIER_ID
, SUP.SUPPLIER_SITE_ID
, CAP.FROM_DATE
, CAP.TO_DATE
, CAP.CAPACITY_PER_DAY
FROM PO_SUPPLIER_ITEM_CAPACITY CAP
, MRP_PO_SUPPLIERS_V SUP
WHERE CAP.ASL_ID = SUP.ASL_ID
AND CAP.USING_ORGANIZATION_ID = SUP.USING_ORGANIZATION_ID
AND TRUNC(NVL(CAP.TO_DATE
, SYSDATE+1)) >= TRUNC(SYSDATE)