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_NET_RESOURCE_AVAIL

Line 6276: FROM MSC_NET_RESOURCE_AVAIL MNRA,

6272: p_resource_id,
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

Line 6454: FROM MSC_NET_RESOURCE_AVAIL MNRA,

6450: p_resource_id,
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

Line 6666: FROM MSC_NET_RESOURCE_AVAIL MNRA,

6662: p_department_id,
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

Line 6836: FROM MSC_NET_RESOURCE_AVAIL MNRA,

6832: p_resource_id,
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

Line 7186: FROM MSC_NET_RESOURCE_AVAIL MNRA,

7182: -- ship_rec_cal changes end
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

Line 7481: FROM MSC_NET_RESOURCE_AVAIL MNRA,

7477: -- ship_rec_cal changes end
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

Line 7810: FROM MSC_NET_RESOURCE_AVAIL MNRA,

7806: -- Unallocated_Quantity
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

Line 8093: FROM MSC_NET_RESOURCE_AVAIL MNRA,

8089: -- Unallocated_Quantity
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