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.

APPS.MRP_ATP_COLLECTION dependencies on MTL_SUPPLY

Line 253: -- insert mtl_supply information, that is PO, REQ, SHIP, RCV

249: AND C.CALENDAR_CODE = P.CALENDAR_CODE
250: AND C.EXCEPTION_SET_ID = P.CALENDAR_EXCEPTION_SET_ID
251: AND C.CALENDAR_DATE = TRUNC(U.EXPECTED_DELIVERY_DATE);
252:
253: -- insert mtl_supply information, that is PO, REQ, SHIP, RCV
254: -- question here,
255: -- I select NVL(S.MRP_PRIMARY_QUANTITY, S.TO_ORG_PRIMARY_QUANTITY)
256: -- as the supply_demand_quantity if discrete mps is included,
257: -- S.TO_ORG_PRIMARY_QUANTITY if not included.

Line 308: MTL_SUPPLY S,

304: NULL,
305: 2, -- supply
306: NULL
307: FROM BOM_CALENDAR_DATES C ,
308: MTL_SUPPLY S,
309: MTL_ATP_RULES R ,
310: MTL_PARAMETERS P ,
311: MTL_SYSTEM_ITEMS I
312: WHERE I.ATP_FLAG in ('C', 'Y')