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.

[Home] [Help]

View: MRP_PO_SUPPLIER_CAPACITY_V

Product:	MRP - Master Scheduling/MRP
Description:	Supplier capacity view
Implementation/DBA Data:	APPS.MRP_PO_SUPPLIER_CAPACITY_V

View Text

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)

Columns

Name
COMPILE_DESIGNATOR
INVENTORY_ITEM_ID
ORGANIZATION_ID
USING_ORGANIZATION_ID
SUPPLIER_ID
SUPPLIER_SITE_ID
START_DATE
END_DATE
CAPACITY_PER_DAY