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 6217: MSC_RESOURCE_REQUIREMENTS REQ,

6213: l_demand_class), 0)) SD_QTY
6214: /*New*/
6215: FROM MSC_DEPARTMENT_RESOURCES DR,
6216: MSC_SUPPLIES S,
6217: MSC_RESOURCE_REQUIREMENTS REQ,
6218: -- 2859130 MSC_CALENDAR_DATES C,
6219: MSC_SYSTEM_ITEMS I,
6220: MSC_UOM_CONVERSIONS MUC
6221: WHERE DR.PLAN_ID = p_plan_id

Line 6390: MSC_RESOURCE_REQUIREMENTS REQ,

6386: l_demand_class), 0)) SD_QTY
6387: /*New*/
6388: FROM MSC_DEPARTMENT_RESOURCES DR,
6389: MSC_SUPPLIES S,
6390: MSC_RESOURCE_REQUIREMENTS REQ,
6391: MSC_CALENDAR_DATES C,
6392: MSC_SYSTEM_ITEMS I,
6393: MSC_UOM_CONVERSIONS MUC
6394: WHERE DR.PLAN_ID = p_plan_id

Line 6612: MSC_RESOURCE_REQUIREMENTS REQ

6608: /*New*/
6609: FROM MSC_DEPARTMENT_RESOURCES DR,
6610: MSC_SUPPLIES S,
6611: MSC_SYSTEM_ITEMS I, -- CTO ODR
6612: MSC_RESOURCE_REQUIREMENTS REQ
6613: -- 2859130 MSC_CALENDAR_DATES C
6614: WHERE DR.PLAN_ID = p_plan_id
6615: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6616: AND DR.RESOURCE_ID = p_resource_id

Line 6776: MSC_RESOURCE_REQUIREMENTS REQ,

6772: /*New*/
6773: FROM MSC_DEPARTMENT_RESOURCES DR,
6774: MSC_SUPPLIES S,
6775: MSC_SYSTEM_ITEMS I, -- CTO ODR
6776: MSC_RESOURCE_REQUIREMENTS REQ,
6777: MSC_CALENDAR_DATES C
6778: WHERE DR.PLAN_ID = p_plan_id
6779: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
6780: AND DR.RESOURCE_ID = p_resource_id

Line 7090: MSC_RESOURCE_REQUIREMENTS REQ,

7086: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
7087: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7088: FROM MSC_DEPARTMENT_RESOURCES DR,
7089: MSC_SUPPLIES S,
7090: MSC_RESOURCE_REQUIREMENTS REQ,
7091: -- 2859130 MSC_CALENDAR_DATES C,
7092: MSC_SYSTEM_ITEMS I,
7093: MSC_UOM_CONVERSIONS MUC
7094: WHERE DR.PLAN_ID = p_plan_id

Line 7381: MSC_RESOURCE_REQUIREMENTS REQ,

7377: DECODE(DR.UOM_CLASS_TYPE, 1, I.UNIT_WEIGHT, 2, UNIT_VOLUME) *
7378: NVL(MUC.CONVERSION_RATE, 1) * NVL(S.NEW_ORDER_QUANTITY,S.FIRM_QUANTITY)
7379: FROM MSC_DEPARTMENT_RESOURCES DR,
7380: MSC_SUPPLIES S,
7381: MSC_RESOURCE_REQUIREMENTS REQ,
7382: MSC_CALENDAR_DATES C,
7383: MSC_SYSTEM_ITEMS I,
7384: MSC_UOM_CONVERSIONS MUC
7385: WHERE DR.PLAN_ID = p_plan_id

Line 7718: MSC_RESOURCE_REQUIREMENTS REQ

7714: -- End Bug 3348095
7715: FROM MSC_DEPARTMENT_RESOURCES DR,
7716: MSC_SUPPLIES S,
7717: MSC_SYSTEM_ITEMS I, -- CTO ODR
7718: MSC_RESOURCE_REQUIREMENTS REQ
7719: -- 2859130 MSC_CALENDAR_DATES C
7720: WHERE DR.PLAN_ID = p_plan_id
7721: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
7722: AND DR.RESOURCE_ID = p_resource_id

Line 7997: MSC_RESOURCE_REQUIREMENTS REQ,

7993: -- End Bug 3348095
7994: FROM MSC_DEPARTMENT_RESOURCES DR,
7995: MSC_SUPPLIES S,
7996: MSC_SYSTEM_ITEMS I, -- CTO ODR
7997: MSC_RESOURCE_REQUIREMENTS REQ,
7998: MSC_CALENDAR_DATES C
7999: WHERE DR.PLAN_ID = p_plan_id
8000: AND NVL(DR.OWNING_DEPARTMENT_ID, DR.DEPARTMENT_ID)=p_department_id
8001: AND DR.RESOURCE_ID = p_resource_id