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_AATP_PVT dependencies on MSC_RESOURCE_REQUIREMENTS

Line 5987: MSC_RESOURCE_REQUIREMENTS REQ,

5983: l_demand_class), 0)) SD_QTY
5984: /*New*/
5985: FROM MSC_DEPARTMENT_RESOURCES DR,
5986: MSC_SUPPLIES S,
5987: MSC_RESOURCE_REQUIREMENTS REQ,
5988: -- 2859130 MSC_CALENDAR_DATES C,
5989: MSC_SYSTEM_ITEMS I,
5990: MSC_UOM_CONVERSIONS MUC
5991: WHERE DR.PLAN_ID = p_plan_id

Line 6160: MSC_RESOURCE_REQUIREMENTS REQ,

6156: l_demand_class), 0)) SD_QTY
6157: /*New*/
6158: FROM MSC_DEPARTMENT_RESOURCES DR,
6159: MSC_SUPPLIES S,
6160: MSC_RESOURCE_REQUIREMENTS REQ,
6161: MSC_CALENDAR_DATES C,
6162: MSC_SYSTEM_ITEMS I,
6163: MSC_UOM_CONVERSIONS MUC
6164: WHERE DR.PLAN_ID = p_plan_id

Line 6382: MSC_RESOURCE_REQUIREMENTS REQ

6378: /*New*/
6379: FROM MSC_DEPARTMENT_RESOURCES DR,
6380: MSC_SUPPLIES S,
6381: MSC_SYSTEM_ITEMS I, -- CTO ODR
6382: MSC_RESOURCE_REQUIREMENTS REQ
6383: -- 2859130 MSC_CALENDAR_DATES C
6384: WHERE DR.PLAN_ID = p_plan_id
6385: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6386: AND DR.RESOURCE_ID = p_resource_id

Line 6546: MSC_RESOURCE_REQUIREMENTS REQ,

6542: /*New*/
6543: FROM MSC_DEPARTMENT_RESOURCES DR,
6544: MSC_SUPPLIES S,
6545: MSC_SYSTEM_ITEMS I, -- CTO ODR
6546: MSC_RESOURCE_REQUIREMENTS REQ,
6547: MSC_CALENDAR_DATES C
6548: WHERE DR.PLAN_ID = p_plan_id
6549: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6550: AND DR.RESOURCE_ID = p_resource_id

Line 6860: MSC_RESOURCE_REQUIREMENTS REQ,

6856: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
6857: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
6858: FROM MSC_DEPARTMENT_RESOURCES DR,
6859: MSC_SUPPLIES S,
6860: MSC_RESOURCE_REQUIREMENTS REQ,
6861: -- 2859130 MSC_CALENDAR_DATES C,
6862: MSC_SYSTEM_ITEMS I,
6863: MSC_UOM_CONVERSIONS MUC
6864: WHERE DR.PLAN_ID = p_plan_id

Line 7151: MSC_RESOURCE_REQUIREMENTS REQ,

7147: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
7148: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7149: FROM MSC_DEPARTMENT_RESOURCES DR,
7150: MSC_SUPPLIES S,
7151: MSC_RESOURCE_REQUIREMENTS REQ,
7152: MSC_CALENDAR_DATES C,
7153: MSC_SYSTEM_ITEMS I,
7154: MSC_UOM_CONVERSIONS MUC
7155: WHERE DR.PLAN_ID = p_plan_id

Line 7488: MSC_RESOURCE_REQUIREMENTS REQ

7484: -- End Bug 3348095
7485: FROM MSC_DEPARTMENT_RESOURCES DR,
7486: MSC_SUPPLIES S,
7487: MSC_SYSTEM_ITEMS I, -- CTO ODR
7488: MSC_RESOURCE_REQUIREMENTS REQ
7489: -- 2859130 MSC_CALENDAR_DATES C
7490: WHERE DR.PLAN_ID = p_plan_id
7491: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7492: AND DR.RESOURCE_ID = p_resource_id

Line 7767: MSC_RESOURCE_REQUIREMENTS REQ,

7763: -- End Bug 3348095
7764: FROM MSC_DEPARTMENT_RESOURCES DR,
7765: MSC_SUPPLIES S,
7766: MSC_SYSTEM_ITEMS I, -- CTO ODR
7767: MSC_RESOURCE_REQUIREMENTS REQ,
7768: MSC_CALENDAR_DATES C
7769: WHERE DR.PLAN_ID = p_plan_id
7770: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7771: AND DR.RESOURCE_ID = p_resource_id