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_NET_RESOURCE_AVAIL

Line 6046: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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

Line 6224: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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

Line 6436: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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

Line 6606: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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

Line 6956: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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

Line 7251: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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

Line 7580: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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

Line 7863: FROM MSC_NET_RESOURCE_AVAIL MNRA,

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