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_CL_WIP_ODS_LOAD dependencies on MSC_ITEM_ID_LID

Line 95: ||' MSC_ITEM_ID_LID t1 '

91: ||' t1.inventory_item_id EQUIPMENT_ITEM_ID,'
92: ||' resi.SR_INSTANCE_ID'
93: ||' FROM '||lv_supplies_tbl||' ms,'
94: ||' MSC_ST_JOB_OP_RES_INSTANCES resi,'
95: ||' MSC_ITEM_ID_LID t1 '
96: ||' WHERE resi.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
97: ||' AND ms.PLAN_ID= -1'
98: ||' AND ms.SR_INSTANCE_ID= resi.SR_INSTANCE_ID'
99: ||' AND ms.DISPOSITION_ID= resi.WIP_ENTITY_ID'

Line 163: ||' MSC_ITEM_ID_LID t1 '

159: --||' resi.RES_INSTANCE_HOURS,'
160: ||' resi.BATCH_NUMBER'
161: ||' FROM '||lv_supplies_tbl||' ms,'
162: ||' MSC_ST_JOB_OP_RES_INSTANCES resi, '
163: ||' MSC_ITEM_ID_LID t1 '
164: ||' WHERE resi.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
165: ||' AND ms.PLAN_ID= -1'
166: ||' AND ms.SR_INSTANCE_ID= resi.SR_INSTANCE_ID'
167: ||' AND ms.DISPOSITION_ID= resi.WIP_ENTITY_ID'

Line 1306: ||' MSC_ITEM_ID_LID cmp_itm, '

1302: ||' req.COMPONENT_SEQUENCE_ID,'
1303: ||' req.SR_INSTANCE_ID'
1304: ||' FROM '||lv_supplies_tbl||' ms,'
1305: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1306: ||' MSC_ITEM_ID_LID cmp_itm, '
1307: ||' MSC_ITEM_ID_LID pri_cmp, '
1308: ||' MSC_ITEM_ID_LID src_ptm '
1309: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1310: ||' AND ms.PLAN_ID= -1'

Line 1307: ||' MSC_ITEM_ID_LID pri_cmp, '

1303: ||' req.SR_INSTANCE_ID'
1304: ||' FROM '||lv_supplies_tbl||' ms,'
1305: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1306: ||' MSC_ITEM_ID_LID cmp_itm, '
1307: ||' MSC_ITEM_ID_LID pri_cmp, '
1308: ||' MSC_ITEM_ID_LID src_ptm '
1309: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1310: ||' AND ms.PLAN_ID= -1'
1311: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'

Line 1308: ||' MSC_ITEM_ID_LID src_ptm '

1304: ||' FROM '||lv_supplies_tbl||' ms,'
1305: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1306: ||' MSC_ITEM_ID_LID cmp_itm, '
1307: ||' MSC_ITEM_ID_LID pri_cmp, '
1308: ||' MSC_ITEM_ID_LID src_ptm '
1309: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1310: ||' AND ms.PLAN_ID= -1'
1311: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'
1312: ||' AND ms.DISPOSITION_ID= req.WIP_ENTITY_ID'

Line 1389: ||' MSC_ITEM_ID_LID cmp_itm, '

1385: ||' req.TO_END_ITEM_UNIT_NUMBER,'
1386: ||' req.COMPONENT_SCALING_TYPE' /* Discrete Mfg Enahancements Bug 4492736 */
1387: ||' FROM '||lv_supplies_tbl||' ms,'
1388: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1389: ||' MSC_ITEM_ID_LID cmp_itm, '
1390: ||' MSC_ITEM_ID_LID pri_cmp, '
1391: ||' MSC_ITEM_ID_LID src_ptm '
1392: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1393: ||' AND ms.PLAN_ID= -1'

Line 1390: ||' MSC_ITEM_ID_LID pri_cmp, '

1386: ||' req.COMPONENT_SCALING_TYPE' /* Discrete Mfg Enahancements Bug 4492736 */
1387: ||' FROM '||lv_supplies_tbl||' ms,'
1388: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1389: ||' MSC_ITEM_ID_LID cmp_itm, '
1390: ||' MSC_ITEM_ID_LID pri_cmp, '
1391: ||' MSC_ITEM_ID_LID src_ptm '
1392: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1393: ||' AND ms.PLAN_ID= -1'
1394: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'

Line 1391: ||' MSC_ITEM_ID_LID src_ptm '

1387: ||' FROM '||lv_supplies_tbl||' ms,'
1388: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1389: ||' MSC_ITEM_ID_LID cmp_itm, '
1390: ||' MSC_ITEM_ID_LID pri_cmp, '
1391: ||' MSC_ITEM_ID_LID src_ptm '
1392: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1393: ||' AND ms.PLAN_ID= -1'
1394: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'
1395: ||' AND ms.DISPOSITION_ID= req.WIP_ENTITY_ID'

Line 1864: ||' MSC_ITEM_ID_LID t1'

1860: ||' FROM '||lv_supplies_tbl||' ms,'
1861: ||' '||lv_supplies_tbl||' ms1,'
1862: ||' '||lv_supplies_tbl||' ms2,'
1863: ||' MSC_ST_JOB_OPERATION_NETWORKS nwk,'
1864: ||' MSC_ITEM_ID_LID t1'
1865: ||' WHERE nwk.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1866: ||' AND ms.PLAN_ID= -1'
1867: ||' AND ms.SR_INSTANCE_ID= nwk.SR_INSTANCE_ID'
1868: ||' AND ms.DISPOSITION_ID= nwk.WIP_ENTITY_ID'

Line 2226: ||' MSC_ITEM_ID_LID t1'

2222: ||' msrir.SERIAL_NUMBER, '
2223: ||' t1.INVENTORY_ITEM_ID equipment_item_id'
2224: ||' FROM '||lv_supplies_tbl||' ms,'
2225: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir,'
2226: ||' MSC_ITEM_ID_LID t1'
2227: ||' WHERE msrir.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2228: ||' AND ms.PLAN_ID= -1'
2229: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID'
2230: ||' AND ms.DISPOSITION_ID= msrir.WIP_ENTITY_ID'

Line 2341: ||' MSC_ITEM_ID_LID t1 '

2337: ||' :v_current_date, '
2338: ||' :v_current_user '
2339: ||' FROM '||lv_supplies_tbl||' ms, '
2340: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir, '
2341: ||' MSC_ITEM_ID_LID t1 '
2342: ||' WHERE msrir.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2343: ||' AND ms.PLAN_ID= -1 '
2344: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID '
2345: ||' AND ms.DISPOSITION_ID= msrir.WIP_ENTITY_ID '

Line 2637: FROM MSC_ITEM_ID_LID t1,

2633: t1.INVENTORY_ITEM_ID,
2634: msd.ORIGINATION_TYPE,
2635: msd.SR_INSTANCE_ID,
2636: msd.ORGANIZATION_ID
2637: FROM MSC_ITEM_ID_LID t1,
2638: MSC_ST_DEMANDS msd
2639: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2640: AND msd.ORIGINATION_TYPE IN (2,3,4,25,50,70) /* ds change change 50 eam demand */
2641: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

Line 2804: ||' FROM MSC_ITEM_ID_LID t1,'

2800: ||' :v_current_date,'
2801: ||' :v_current_user,'
2802: ||' :v_current_date,'
2803: ||' :v_current_user '
2804: ||' FROM MSC_ITEM_ID_LID t1,'
2805: ||' MSC_ITEM_ID_LID t2,'
2806: ||' MSC_ITEM_ID_LID t3,'
2807: || lv_supplies_tbl||' ms,'
2808: ||' MSC_ST_DEMANDS msd'

Line 2805: ||' MSC_ITEM_ID_LID t2,'

2801: ||' :v_current_user,'
2802: ||' :v_current_date,'
2803: ||' :v_current_user '
2804: ||' FROM MSC_ITEM_ID_LID t1,'
2805: ||' MSC_ITEM_ID_LID t2,'
2806: ||' MSC_ITEM_ID_LID t3,'
2807: || lv_supplies_tbl||' ms,'
2808: ||' MSC_ST_DEMANDS msd'
2809: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

Line 2806: ||' MSC_ITEM_ID_LID t3,'

2802: ||' :v_current_date,'
2803: ||' :v_current_user '
2804: ||' FROM MSC_ITEM_ID_LID t1,'
2805: ||' MSC_ITEM_ID_LID t2,'
2806: ||' MSC_ITEM_ID_LID t3,'
2807: || lv_supplies_tbl||' ms,'
2808: ||' MSC_ST_DEMANDS msd'
2809: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2810: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/

Line 3015: ||' FROM MSC_ITEM_ID_LID t1,'

3011: ||' t3.inventory_item_id ASSET_ITEM_ID,' /* ds change change*/
3012: ||' msd.ASSET_SERIAL_NUMBER,' /* ds change change*/
3013: ||' msd.COMPONENT_SCALING_TYPE,' /* Discrete Mfg Enahancements Bug 4492736 */
3014: ||' msd.COMPONENT_YIELD_FACTOR' /* Discrete Mfg Enahancements Bug 4492743 */
3015: ||' FROM MSC_ITEM_ID_LID t1,'
3016: ||' MSC_ITEM_ID_LID t2,'
3017: ||' MSC_ITEM_ID_LID t3,'
3018: || lv_supplies_tbl||' ms,'
3019: ||' MSC_ST_DEMANDS msd'

Line 3016: ||' MSC_ITEM_ID_LID t2,'

3012: ||' msd.ASSET_SERIAL_NUMBER,' /* ds change change*/
3013: ||' msd.COMPONENT_SCALING_TYPE,' /* Discrete Mfg Enahancements Bug 4492736 */
3014: ||' msd.COMPONENT_YIELD_FACTOR' /* Discrete Mfg Enahancements Bug 4492743 */
3015: ||' FROM MSC_ITEM_ID_LID t1,'
3016: ||' MSC_ITEM_ID_LID t2,'
3017: ||' MSC_ITEM_ID_LID t3,'
3018: || lv_supplies_tbl||' ms,'
3019: ||' MSC_ST_DEMANDS msd'
3020: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

Line 3017: ||' MSC_ITEM_ID_LID t3,'

3013: ||' msd.COMPONENT_SCALING_TYPE,' /* Discrete Mfg Enahancements Bug 4492736 */
3014: ||' msd.COMPONENT_YIELD_FACTOR' /* Discrete Mfg Enahancements Bug 4492743 */
3015: ||' FROM MSC_ITEM_ID_LID t1,'
3016: ||' MSC_ITEM_ID_LID t2,'
3017: ||' MSC_ITEM_ID_LID t3,'
3018: || lv_supplies_tbl||' ms,'
3019: ||' MSC_ST_DEMANDS msd'
3020: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3021: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/

Line 3462: ||' MSC_ITEM_ID_LID miil'

3458: ||' msrr.ACTIVITY_NAME, '
3459: ||' msrr.OPERATION_NAME '
3460: ||' FROM '||lv_supplies_tbl||' ms,'
3461: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr,'
3462: ||' MSC_ITEM_ID_LID miil'
3463: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3464: ||' AND ms.PLAN_ID= -1'
3465: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'
3466: ||' AND ms.DISPOSITION_ID= msrr.WIP_ENTITY_ID'

Line 3724: ||' MSC_ITEM_ID_LID miil '

3720: ||' :v_current_date, '
3721: ||' :v_current_user '
3722: ||' FROM '||lv_supplies_tbl||' ms, '
3723: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr, '
3724: ||' MSC_ITEM_ID_LID miil '
3725: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3726: ||' AND ms.PLAN_ID= -1'
3727: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'
3728: ||' AND ms.DISPOSITION_ID= msrr.WIP_ENTITY_ID'