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 94: ||' MSC_ITEM_ID_LID t1 '

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

Line 162: ||' MSC_ITEM_ID_LID t1 '

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

Line 1281: ||' MSC_ITEM_ID_LID cmp_itm, '

1277: ||' req.COMPONENT_SEQUENCE_ID,'
1278: ||' req.SR_INSTANCE_ID'
1279: ||' FROM '||lv_supplies_tbl||' ms,'
1280: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1281: ||' MSC_ITEM_ID_LID cmp_itm, '
1282: ||' MSC_ITEM_ID_LID pri_cmp, '
1283: ||' MSC_ITEM_ID_LID src_ptm '
1284: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1285: ||' AND ms.PLAN_ID= -1'

Line 1282: ||' MSC_ITEM_ID_LID pri_cmp, '

1278: ||' req.SR_INSTANCE_ID'
1279: ||' FROM '||lv_supplies_tbl||' ms,'
1280: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1281: ||' MSC_ITEM_ID_LID cmp_itm, '
1282: ||' MSC_ITEM_ID_LID pri_cmp, '
1283: ||' MSC_ITEM_ID_LID src_ptm '
1284: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1285: ||' AND ms.PLAN_ID= -1'
1286: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'

Line 1283: ||' MSC_ITEM_ID_LID src_ptm '

1279: ||' FROM '||lv_supplies_tbl||' ms,'
1280: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1281: ||' MSC_ITEM_ID_LID cmp_itm, '
1282: ||' MSC_ITEM_ID_LID pri_cmp, '
1283: ||' MSC_ITEM_ID_LID src_ptm '
1284: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1285: ||' AND ms.PLAN_ID= -1'
1286: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'
1287: ||' AND ms.DISPOSITION_ID= req.WIP_ENTITY_ID'

Line 1364: ||' MSC_ITEM_ID_LID cmp_itm, '

1360: ||' req.TO_END_ITEM_UNIT_NUMBER,'
1361: ||' req.COMPONENT_SCALING_TYPE' /* Discrete Mfg Enahancements Bug 4492736 */
1362: ||' FROM '||lv_supplies_tbl||' ms,'
1363: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1364: ||' MSC_ITEM_ID_LID cmp_itm, '
1365: ||' MSC_ITEM_ID_LID pri_cmp, '
1366: ||' MSC_ITEM_ID_LID src_ptm '
1367: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1368: ||' AND ms.PLAN_ID= -1'

Line 1365: ||' MSC_ITEM_ID_LID pri_cmp, '

1361: ||' req.COMPONENT_SCALING_TYPE' /* Discrete Mfg Enahancements Bug 4492736 */
1362: ||' FROM '||lv_supplies_tbl||' ms,'
1363: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1364: ||' MSC_ITEM_ID_LID cmp_itm, '
1365: ||' MSC_ITEM_ID_LID pri_cmp, '
1366: ||' MSC_ITEM_ID_LID src_ptm '
1367: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1368: ||' AND ms.PLAN_ID= -1'
1369: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'

Line 1366: ||' MSC_ITEM_ID_LID src_ptm '

1362: ||' FROM '||lv_supplies_tbl||' ms,'
1363: ||' MSC_ST_JOB_REQUIREMENT_OPS req,'
1364: ||' MSC_ITEM_ID_LID cmp_itm, '
1365: ||' MSC_ITEM_ID_LID pri_cmp, '
1366: ||' MSC_ITEM_ID_LID src_ptm '
1367: ||' WHERE req.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1368: ||' AND ms.PLAN_ID= -1'
1369: ||' AND ms.SR_INSTANCE_ID= req.SR_INSTANCE_ID'
1370: ||' AND ms.DISPOSITION_ID= req.WIP_ENTITY_ID'

Line 1839: ||' MSC_ITEM_ID_LID t1'

1835: ||' FROM '||lv_supplies_tbl||' ms,'
1836: ||' '||lv_supplies_tbl||' ms1,'
1837: ||' '||lv_supplies_tbl||' ms2,'
1838: ||' MSC_ST_JOB_OPERATION_NETWORKS nwk,'
1839: ||' MSC_ITEM_ID_LID t1'
1840: ||' WHERE nwk.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
1841: ||' AND ms.PLAN_ID= -1'
1842: ||' AND ms.SR_INSTANCE_ID= nwk.SR_INSTANCE_ID'
1843: ||' AND ms.DISPOSITION_ID= nwk.WIP_ENTITY_ID'

Line 2201: ||' MSC_ITEM_ID_LID t1'

2197: ||' msrir.SERIAL_NUMBER, '
2198: ||' t1.INVENTORY_ITEM_ID equipment_item_id'
2199: ||' FROM '||lv_supplies_tbl||' ms,'
2200: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir,'
2201: ||' MSC_ITEM_ID_LID t1'
2202: ||' WHERE msrir.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2203: ||' AND ms.PLAN_ID= -1'
2204: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID'
2205: ||' AND ms.DISPOSITION_ID= msrir.WIP_ENTITY_ID'

Line 2316: ||' MSC_ITEM_ID_LID t1 '

2312: ||' :v_current_date, '
2313: ||' :v_current_user '
2314: ||' FROM '||lv_supplies_tbl||' ms, '
2315: ||' MSC_ST_RESOURCE_INSTANCE_REQS msrir, '
2316: ||' MSC_ITEM_ID_LID t1 '
2317: ||' WHERE msrir.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2318: ||' AND ms.PLAN_ID= -1 '
2319: ||' AND ms.SR_INSTANCE_ID= msrir.SR_INSTANCE_ID '
2320: ||' AND ms.DISPOSITION_ID= msrir.WIP_ENTITY_ID '

Line 2612: FROM MSC_ITEM_ID_LID t1,

2608: t1.INVENTORY_ITEM_ID,
2609: msd.ORIGINATION_TYPE,
2610: msd.SR_INSTANCE_ID,
2611: msd.ORGANIZATION_ID
2612: FROM MSC_ITEM_ID_LID t1,
2613: MSC_ST_DEMANDS msd
2614: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
2615: AND msd.ORIGINATION_TYPE IN (2,3,4,25,50) /* ds change change 50 eam demand */
2616: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES

Line 2779: ||' FROM MSC_ITEM_ID_LID t1,'

2775: ||' :v_current_date,'
2776: ||' :v_current_user,'
2777: ||' :v_current_date,'
2778: ||' :v_current_user '
2779: ||' FROM MSC_ITEM_ID_LID t1,'
2780: ||' MSC_ITEM_ID_LID t2,'
2781: ||' MSC_ITEM_ID_LID t3,'
2782: || lv_supplies_tbl||' ms,'
2783: ||' MSC_ST_DEMANDS msd'

Line 2780: ||' MSC_ITEM_ID_LID t2,'

2776: ||' :v_current_user,'
2777: ||' :v_current_date,'
2778: ||' :v_current_user '
2779: ||' FROM MSC_ITEM_ID_LID t1,'
2780: ||' MSC_ITEM_ID_LID t2,'
2781: ||' MSC_ITEM_ID_LID t3,'
2782: || lv_supplies_tbl||' ms,'
2783: ||' MSC_ST_DEMANDS msd'
2784: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

Line 2781: ||' MSC_ITEM_ID_LID t3,'

2777: ||' :v_current_date,'
2778: ||' :v_current_user '
2779: ||' FROM MSC_ITEM_ID_LID t1,'
2780: ||' MSC_ITEM_ID_LID t2,'
2781: ||' MSC_ITEM_ID_LID t3,'
2782: || lv_supplies_tbl||' ms,'
2783: ||' MSC_ST_DEMANDS msd'
2784: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2785: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/

Line 2990: ||' FROM MSC_ITEM_ID_LID t1,'

2986: ||' t3.inventory_item_id ASSET_ITEM_ID,' /* ds change change*/
2987: ||' msd.ASSET_SERIAL_NUMBER,' /* ds change change*/
2988: ||' msd.COMPONENT_SCALING_TYPE,' /* Discrete Mfg Enahancements Bug 4492736 */
2989: ||' msd.COMPONENT_YIELD_FACTOR' /* Discrete Mfg Enahancements Bug 4492743 */
2990: ||' FROM MSC_ITEM_ID_LID t1,'
2991: ||' MSC_ITEM_ID_LID t2,'
2992: ||' MSC_ITEM_ID_LID t3,'
2993: || lv_supplies_tbl||' ms,'
2994: ||' MSC_ST_DEMANDS msd'

Line 2991: ||' MSC_ITEM_ID_LID t2,'

2987: ||' msd.ASSET_SERIAL_NUMBER,' /* ds change change*/
2988: ||' msd.COMPONENT_SCALING_TYPE,' /* Discrete Mfg Enahancements Bug 4492736 */
2989: ||' msd.COMPONENT_YIELD_FACTOR' /* Discrete Mfg Enahancements Bug 4492743 */
2990: ||' FROM MSC_ITEM_ID_LID t1,'
2991: ||' MSC_ITEM_ID_LID t2,'
2992: ||' MSC_ITEM_ID_LID t3,'
2993: || lv_supplies_tbl||' ms,'
2994: ||' MSC_ST_DEMANDS msd'
2995: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id

Line 2992: ||' MSC_ITEM_ID_LID t3,'

2988: ||' msd.COMPONENT_SCALING_TYPE,' /* Discrete Mfg Enahancements Bug 4492736 */
2989: ||' msd.COMPONENT_YIELD_FACTOR' /* Discrete Mfg Enahancements Bug 4492743 */
2990: ||' FROM MSC_ITEM_ID_LID t1,'
2991: ||' MSC_ITEM_ID_LID t2,'
2992: ||' MSC_ITEM_ID_LID t3,'
2993: || lv_supplies_tbl||' ms,'
2994: ||' MSC_ST_DEMANDS msd'
2995: ||' WHERE msd.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
2996: ||' AND msd.ORIGINATION_TYPE IN (2,3,4,25,50)' /* 50 eam demand: ds change change*/

Line 3430: ||' MSC_ITEM_ID_LID miil'

3426: ||' msrr.ACTIVITY_NAME, '
3427: ||' msrr.OPERATION_NAME '
3428: ||' FROM '||lv_supplies_tbl||' ms,'
3429: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr,'
3430: ||' MSC_ITEM_ID_LID miil'
3431: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3432: ||' AND ms.PLAN_ID= -1'
3433: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'
3434: ||' AND ms.DISPOSITION_ID= msrr.WIP_ENTITY_ID'

Line 3676: ||' MSC_ITEM_ID_LID miil '

3672: ||' :v_current_date, '
3673: ||' :v_current_user '
3674: ||' FROM '||lv_supplies_tbl||' ms, '
3675: ||' MSC_ST_RESOURCE_REQUIREMENTS msrr, '
3676: ||' MSC_ITEM_ID_LID miil '
3677: ||' WHERE msrr.SR_INSTANCE_ID= '||MSC_CL_COLLECTION.v_instance_id
3678: ||' AND ms.PLAN_ID= -1'
3679: ||' AND ms.SR_INSTANCE_ID= msrr.SR_INSTANCE_ID'
3680: ||' AND ms.DISPOSITION_ID= msrr.WIP_ENTITY_ID'