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.MSC_ATP_REQ dependencies on MSC_RESOURCE_REQUIREMENTS

Line 160: MSC_RESOURCE_REQUIREMENTS REQ,

156: REQ.DAILY_RESOURCE_HOURS))) SD_QTY
157: -- For ATP created records use resource_hours
158: -- End Bug 3348095
159: FROM MSC_DEPARTMENT_RESOURCES DR,
160: MSC_RESOURCE_REQUIREMENTS REQ,
161: -- CTO Option Dependent Resources ODR
162: -- Option Dependent Resources Capacity Check
163: -- Add Link to Items
164: MSC_SYSTEM_ITEMS I

Line 266: MSC_RESOURCE_REQUIREMENTS REQ,

262: REQ.DAILY_RESOURCE_HOURS))) SD_QTY
263: -- For ATP created records use resource_hours
264: -- End Bug 3348095
265: FROM MSC_DEPARTMENT_RESOURCES DR,
266: MSC_RESOURCE_REQUIREMENTS REQ,
267: -- CTO Option Dependent Resources ODR
268: -- Option Dependent Resources Capacity Check
269: -- Add Link to Items
270: MSC_SYSTEM_ITEMS I,

Line 383: MSC_RESOURCE_REQUIREMENTS REQ,

379: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
380: NVL(MUC.CONVERSION_RATE,1) * NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY) SD_QTY
381:
382: FROM MSC_DEPARTMENT_RESOURCES DR,
383: MSC_RESOURCE_REQUIREMENTS REQ,
384: -- 2859130 MSC_CALENDAR_DATES C,
385: --- add table for resource batching
386: --- these tables are added to determine how much apacity has already been consumed by the
387: --- existing supplies

Line 509: MSC_RESOURCE_REQUIREMENTS REQ,

505: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
506: NVL(MUC.CONVERSION_RATE,1) * NVL(S.NEW_ORDER_QUANTITY, S.FIRM_QUANTITY) SD_QTY
507:
508: FROM MSC_DEPARTMENT_RESOURCES DR,
509: MSC_RESOURCE_REQUIREMENTS REQ,
510: MSC_CALENDAR_DATES C,
511: --- add table for resource batching
512: --- these tables are added to determine how much apacity has already been consumed by the
513: --- existing supplies

Line 699: MSC_RESOURCE_REQUIREMENTS REQ,

695: l_sysdate,
696: FND_GLOBAL.User_ID,
697: FND_GLOBAL.User_ID
698: FROM MSC_DEPARTMENT_RESOURCES DR,
699: MSC_RESOURCE_REQUIREMENTS REQ,
700: -- CTO Option Dependent Resources
701: -- Option Dependent Resources Capacity Check
702: -- Add Link to Items
703: MSC_SYSTEM_ITEMS I

Line 904: MSC_RESOURCE_REQUIREMENTS REQ,

900: l_sysdate,
901: FND_GLOBAL.User_ID,
902: FND_GLOBAL.User_ID
903: FROM MSC_DEPARTMENT_RESOURCES DR,
904: MSC_RESOURCE_REQUIREMENTS REQ,
905: -- CTO Option Dependent Resources
906: -- Option Dependent Resources Capacity Check
907: -- Add Link to Items
908: MSC_SYSTEM_ITEMS I,

Line 1116: MSC_RESOURCE_REQUIREMENTS REQ,

1112: l_sysdate,
1113: FND_GLOBAL.User_ID,
1114: FND_GLOBAL.User_ID
1115: FROM MSC_DEPARTMENT_RESOURCES DR,
1116: MSC_RESOURCE_REQUIREMENTS REQ,
1117: -- 2859130 MSC_CALENDAR_DATES C,
1118: ---tables added for resource batching
1119: MSC_SYSTEM_ITEMS I,
1120: MSC_SUPPLIES S,

Line 1339: MSC_RESOURCE_REQUIREMENTS REQ,

1335: l_sysdate,
1336: FND_GLOBAL.User_ID,
1337: FND_GLOBAL.User_ID
1338: FROM MSC_DEPARTMENT_RESOURCES DR,
1339: MSC_RESOURCE_REQUIREMENTS REQ,
1340: MSC_CALENDAR_DATES C,
1341: ---tables added for resource batching
1342: MSC_SYSTEM_ITEMS I,
1343: MSC_SUPPLIES S,

Line 1508: MSC_RESOURCE_REQUIREMENTS REQ,

1504: SELECT TRUNC(NVL(REQ.END_DATE, REQ.START_DATE)) SD_DATE,
1505: -- End Bug 3348095
1506: -1 * REQ.RESOURCE_HOURS SD_QTY -- Summary enhancement: Need to bother only about ATP generated records
1507: FROM MSC_DEPARTMENT_RESOURCES DR,
1508: MSC_RESOURCE_REQUIREMENTS REQ,
1509: MSC_PLANS P -- For summary enhancement
1510: --bug3394866
1511: WHERE DR.PLAN_ID = p_plan_id
1512: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_dept_id