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.

[Home] [Help]

APPS.MSC_AATP_PVT dependencies on MSC_RESOURCE_HIERARCHY_MV

Line 5916: FROM msc_resource_hierarchy_mv

5912: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'l_level_id = '||l_level_id);
5913: END IF;
5914: SELECT demand_class, priority
5915: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab
5916: FROM msc_resource_hierarchy_mv
5917: WHERE department_id = p_department_id
5918: AND resource_id = p_resource_id
5919: AND organization_id = p_organization_id
5920: AND sr_instance_id = p_instance_id

Line 5933: FROM msc_resource_hierarchy_mv

5929: msc_sch_wb.atp_debug('Res_Alloc_Cum_Atp: ' || 'l_level_id = '||l_level_id);
5930: END IF;
5931: SELECT demand_class, priority
5932: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab
5933: FROM msc_resource_hierarchy_mv
5934: WHERE department_id = p_department_id
5935: AND resource_id = p_resource_id
5936: AND organization_id = p_organization_id
5937: AND sr_instance_id = p_instance_id

Line 5952: FROM msc_resource_hierarchy_mv mv1

5948: END IF;
5949: SELECT mv1.demand_class, mv1.priority, mv1.class, mv1.partner_id
5950: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab,
5951: l_class_tab, l_partner_tab
5952: FROM msc_resource_hierarchy_mv mv1
5953: WHERE mv1.department_id = p_department_id
5954: AND mv1.resource_id = p_resource_id
5955: AND mv1.organization_id = p_organization_id
5956: AND mv1.sr_instance_id = p_instance_id

Line 5975: FROM msc_resource_hierarchy_mv mv1

5971: END IF;
5972: SELECT mv1.demand_class, mv1.priority, mv1.class, mv1.partner_id
5973: BULK COLLECT INTO l_demand_class_tab, l_demand_class_priority_tab,
5974: l_class_tab, l_partner_tab
5975: FROM msc_resource_hierarchy_mv mv1
5976: WHERE mv1.department_id = p_department_id
5977: AND mv1.resource_id = p_resource_id
5978: AND mv1.organization_id = p_organization_id
5979: AND mv1.sr_instance_id = p_instance_id

Line 6277: msc_resource_hierarchy_mv MRHM

6273: l_demand_class,
6274: SHIFT_DATE),1) SD_QTY
6275: */
6276: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6277: msc_resource_hierarchy_mv MRHM
6278: WHERE MNRA.PLAN_ID = p_plan_id
6279: AND NVL(MNRA.PARENT_ID, -2) <> -1
6280: AND MNRA.SR_INSTANCE_ID = p_instance_id
6281: AND MNRA.RESOURCE_ID = p_resource_id

Line 6455: msc_resource_hierarchy_mv MRHM

6451: l_demand_class,
6452: SHIFT_DATE),1) SD_QTY
6453: */
6454: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6455: msc_resource_hierarchy_mv MRHM
6456: WHERE MNRA.PLAN_ID = p_plan_id
6457: AND NVL(MNRA.PARENT_ID, -2) <> -1
6458: AND MNRA.SR_INSTANCE_ID = p_instance_id
6459: AND MNRA.RESOURCE_ID = p_resource_id

Line 6667: msc_resource_hierarchy_mv MRHM

6663: p_resource_id,
6664: l_demand_class,
6665: SHIFT_DATE),1) SD_QTY */
6666: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6667: msc_resource_hierarchy_mv MRHM
6668: WHERE MNRA.PLAN_ID = p_plan_id
6669: AND NVL(MNRA.PARENT_ID, -2) <> -1
6670: AND MNRA.SR_INSTANCE_ID = p_instance_id
6671: AND MNRA.RESOURCE_ID = p_resource_id

Line 6837: msc_resource_hierarchy_mv MRHM

6833: l_demand_class,
6834: SHIFT_DATE),1) SD_QTY
6835: */
6836: FROM MSC_NET_RESOURCE_AVAIL MNRA,
6837: msc_resource_hierarchy_mv MRHM
6838: WHERE MNRA.PLAN_ID = p_plan_id
6839: AND NVL(MNRA.PARENT_ID, -2) <> -1
6840: AND MNRA.SR_INSTANCE_ID = p_instance_id
6841: AND MNRA.RESOURCE_ID = p_resource_id

Line 7187: msc_resource_hierarchy_mv MRHM

7183: MNRA.CAPACITY_UNITS * p_max_capacity * p_res_conversion_rate * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
7184: MNRA.to_time,MNRA.to_time + 24*3600,
7185: MNRA.to_time) - MNRA.from_time)/3600)
7186: FROM MSC_NET_RESOURCE_AVAIL MNRA,
7187: msc_resource_hierarchy_mv MRHM
7188: WHERE MNRA.PLAN_ID = p_plan_id
7189: AND NVL(MNRA.PARENT_ID, -2) <> -1
7190: AND MNRA.SR_INSTANCE_ID = p_instance_id
7191: AND MNRA.RESOURCE_ID = p_resource_id

Line 7482: msc_resource_hierarchy_mv MRHM

7478: MNRA.CAPACITY_UNITS * p_max_capacity * p_res_conversion_rate * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
7479: MNRA.to_time,MNRA.to_time + 24*3600,
7480: MNRA.to_time) - MNRA.from_time)/3600)
7481: FROM MSC_NET_RESOURCE_AVAIL MNRA,
7482: msc_resource_hierarchy_mv MRHM
7483: WHERE MNRA.PLAN_ID = p_plan_id
7484: AND NVL(MNRA.PARENT_ID, -2) <> -1
7485: AND MNRA.SR_INSTANCE_ID = p_instance_id
7486: AND MNRA.RESOURCE_ID = p_resource_id

Line 7811: msc_resource_hierarchy_mv MRHM

7807: MNRA.CAPACITY_UNITS * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
7808: MNRA.to_time,MNRA.to_time + 24*3600,
7809: MNRA.to_time) - MNRA.from_time)/3600)
7810: FROM MSC_NET_RESOURCE_AVAIL MNRA,
7811: msc_resource_hierarchy_mv MRHM
7812: WHERE MNRA.PLAN_ID = p_plan_id
7813: AND NVL(MNRA.PARENT_ID, -2) <> -1
7814: AND MNRA.SR_INSTANCE_ID = p_instance_id
7815: AND MNRA.RESOURCE_ID = p_resource_id

Line 8094: msc_resource_hierarchy_mv MRHM

8090: MNRA.CAPACITY_UNITS * ((DECODE(LEAST(MNRA.from_time, MNRA.to_time),
8091: MNRA.to_time,MNRA.to_time + 24*3600,
8092: MNRA.to_time) - MNRA.from_time)/3600)
8093: FROM MSC_NET_RESOURCE_AVAIL MNRA,
8094: msc_resource_hierarchy_mv MRHM
8095: WHERE MNRA.PLAN_ID = p_plan_id
8096: AND NVL(MNRA.PARENT_ID, -2) <> -1
8097: AND MNRA.SR_INSTANCE_ID = p_instance_id
8098: AND MNRA.RESOURCE_ID = p_resource_id

Line 10481: FROM msc_resource_hierarchy_mv

10477: --bug3948494 removed distinct and introduced rownum
10478: --SELECT distinct allocation_rule_name, time_phase_id
10479: SELECT allocation_rule_name, time_phase_id
10480: INTO l_rule_name, l_time_phase
10481: FROM msc_resource_hierarchy_mv
10482: WHERE department_id = p_dept_id
10483: AND resource_id = p_res_id
10484: AND organization_id = p_org_id
10485: AND sr_instance_id = p_instance_id

Line 10516: FROM msc_resource_hierarchy_mv

10512: WHEN NO_DATA_FOUND THEN
10513: IF G_HIERARCHY_PROFILE = 1 THEN
10514: SELECT DECODE(count(allocation_percent), 0, NULL, 0)
10515: INTO x_alloc_percent
10516: FROM msc_resource_hierarchy_mv
10517: WHERE department_id = p_dept_id
10518: AND resource_id = p_res_id
10519: AND organization_id = p_org_id
10520: AND sr_instance_id = p_instance_id