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_HIERARCHY_MV

Line 5686: FROM msc_resource_hierarchy_mv

5682: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'l_level_id = '||l_level_id);
5683: END IF;
5684: SELECT demand_class, priority
5685: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab
5686: FROM msc_resource_hierarchy_mv
5687: WHERE department_id = p_department_id
5688: AND resource_id = p_resource_id
5689: AND organization_id = p_organization_id
5690: AND sr_instance_id = p_instance_id

Line 5703: FROM msc_resource_hierarchy_mv

5699: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'l_level_id = '||l_level_id);
5700: END IF;
5701: SELECT demand_class, priority
5702: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab
5703: FROM msc_resource_hierarchy_mv
5704: WHERE department_id = p_department_id
5705: AND resource_id = p_resource_id
5706: AND organization_id = p_organization_id
5707: AND sr_instance_id = p_instance_id

Line 5722: FROM msc_resource_hierarchy_mv mv1

5718: END IF;
5719: SELECT mv1.demand_class, mv1.priority, mv1.class, mv1.partner_id
5720: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab,
5721: l_class_tab, l_partner_tab
5722: FROM msc_resource_hierarchy_mv mv1
5723: WHERE mv1.department_id = p_department_id
5724: AND mv1.resource_id = p_resource_id
5725: AND mv1.organization_id = p_organization_id
5726: AND mv1.sr_instance_id = p_instance_id

Line 5745: FROM msc_resource_hierarchy_mv mv1

5741: END IF;
5742: SELECT mv1.demand_class, mv1.priority, mv1.class, mv1.partner_id
5743: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab,
5744: l_class_tab, l_partner_tab
5745: FROM msc_resource_hierarchy_mv mv1
5746: WHERE mv1.department_id = p_department_id
5747: AND mv1.resource_id = p_resource_id
5748: AND mv1.organization_id = p_organization_id
5749: AND mv1.sr_instance_id = p_instance_id

Line 6047: msc_resource_hierarchy_mv MRHM

6043: l_demand_class,
6044: SHIFT_DATE),1) SD_QTY
6045: */
6046: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6047: msc_resource_hierarchy_mv MRHM
6048: WHERE MNRA.PLAN_ID = p_plan_id
6049: AND NVL(MNRA.PARENT_ID, -2) <> -1
6050: AND MNRA.SR_INSTANCE_ID = p_instance_id
6051: AND MNRA.RESOURCE_ID = p_resource_id

Line 6225: msc_resource_hierarchy_mv MRHM

6221: l_demand_class,
6222: SHIFT_DATE),1) SD_QTY
6223: */
6224: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6225: msc_resource_hierarchy_mv MRHM
6226: WHERE MNRA.PLAN_ID = p_plan_id
6227: AND NVL(MNRA.PARENT_ID, -2) <> -1
6228: AND MNRA.SR_INSTANCE_ID = p_instance_id
6229: AND MNRA.RESOURCE_ID = p_resource_id

Line 6437: msc_resource_hierarchy_mv MRHM

6433: p_resource_id,
6434: l_demand_class,
6435: SHIFT_DATE),1) SD_QTY */
6436: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6437: msc_resource_hierarchy_mv MRHM
6438: WHERE MNRA.PLAN_ID = p_plan_id
6439: AND NVL(MNRA.PARENT_ID, -2) <> -1
6440: AND MNRA.SR_INSTANCE_ID = p_instance_id
6441: AND MNRA.RESOURCE_ID = p_resource_id

Line 6607: msc_resource_hierarchy_mv MRHM

6603: l_demand_class,
6604: SHIFT_DATE),1) SD_QTY
6605: */
6606: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6607: msc_resource_hierarchy_mv MRHM
6608: WHERE MNRA.PLAN_ID = p_plan_id
6609: AND NVL(MNRA.PARENT_ID, -2) <> -1
6610: AND MNRA.SR_INSTANCE_ID = p_instance_id
6611: AND MNRA.RESOURCE_ID = p_resource_id

Line 6957: msc_resource_hierarchy_mv MRHM

6953: MNRA.CAPACITY_UNITS * p_max_capacity * p_res_conversion_rate * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
6954: MNRA.to_time,MNRA.to_time + 24*3600,
6955: MNRA.to_time) - MNRA.from_time)/3600)
6956: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6957: msc_resource_hierarchy_mv MRHM
6958: WHERE MNRA.PLAN_ID = p_plan_id
6959: AND NVL(MNRA.PARENT_ID, -2) <> -1
6960: AND MNRA.SR_INSTANCE_ID = p_instance_id
6961: AND MNRA.RESOURCE_ID = p_resource_id

Line 7252: msc_resource_hierarchy_mv MRHM

7248: MNRA.CAPACITY_UNITS * p_max_capacity * p_res_conversion_rate * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
7249: MNRA.to_time,MNRA.to_time + 24*3600,
7250: MNRA.to_time) - MNRA.from_time)/3600)
7251: FROM MSC_NET_RESOURCE_AVAIL MNRA,
7252: msc_resource_hierarchy_mv MRHM
7253: WHERE MNRA.PLAN_ID = p_plan_id
7254: AND NVL(MNRA.PARENT_ID, -2) <> -1
7255: AND MNRA.SR_INSTANCE_ID = p_instance_id
7256: AND MNRA.RESOURCE_ID = p_resource_id

Line 7581: msc_resource_hierarchy_mv MRHM

7577: MNRA.CAPACITY_UNITS * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
7578: MNRA.to_time,MNRA.to_time + 24*3600,
7579: MNRA.to_time) - MNRA.from_time)/3600)
7580: FROM MSC_NET_RESOURCE_AVAIL MNRA,
7581: msc_resource_hierarchy_mv MRHM
7582: WHERE MNRA.PLAN_ID = p_plan_id
7583: AND NVL(MNRA.PARENT_ID, -2) <> -1
7584: AND MNRA.SR_INSTANCE_ID = p_instance_id
7585: AND MNRA.RESOURCE_ID = p_resource_id

Line 7864: msc_resource_hierarchy_mv MRHM

7860: MNRA.CAPACITY_UNITS * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
7861: MNRA.to_time,MNRA.to_time + 24*3600,
7862: MNRA.to_time) - MNRA.from_time)/3600)
7863: FROM MSC_NET_RESOURCE_AVAIL MNRA,
7864: msc_resource_hierarchy_mv MRHM
7865: WHERE MNRA.PLAN_ID = p_plan_id
7866: AND NVL(MNRA.PARENT_ID, -2) <> -1
7867: AND MNRA.SR_INSTANCE_ID = p_instance_id
7868: AND MNRA.RESOURCE_ID = p_resource_id

Line 10250: FROM msc_resource_hierarchy_mv

10246: --bug3948494 removed distinct and introduced rownum
10247: --SELECT distinct allocation_rule_name, time_phase_id
10248: SELECT allocation_rule_name, time_phase_id
10249: INTO l_rule_name, l_time_phase
10250: FROM msc_resource_hierarchy_mv
10251: WHERE department_id = p_dept_id
10252: AND resource_id = p_res_id
10253: AND organization_id = p_org_id
10254: AND sr_instance_id = p_instance_id

Line 10285: FROM msc_resource_hierarchy_mv

10281: WHEN NO_DATA_FOUND THEN
10282: IF G_HIERARCHY_PROFILE = 1 THEN
10283: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
10284: INTO x_alloc_percent
10285: FROM msc_resource_hierarchy_mv
10286: WHERE department_id = p_dept_id
10287: AND resource_id = p_res_id
10288: AND organization_id = p_org_id
10289: AND sr_instance_id = p_instance_id