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_EAM_ODS_LOAD dependencies on MSC_EAM_ACT_ASSOCIATIONS

Line 63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',

59: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR
60: MSC_CL_COLLECTION.v_is_partial_refresh) THEN
61: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag =
62: MSC_UTIL.G_ALL_ORGANIZATIONS THEN
63: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
64: MSC_CL_COLLECTION.v_instance_id,
65: -1);
66: ELSE
67: MSC_CL_COLLECTION.v_sub_str :=

Line 69: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',

65: -1);
66: ELSE
67: MSC_CL_COLLECTION.v_sub_str :=
68: ' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
69: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_EAM_ACT_ASSOCIATIONS',
70: MSC_CL_COLLECTION.v_instance_id,
71: null,
72: MSC_CL_COLLECTION.v_sub_str);
73: END IF;

Line 80: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';

76: -- ========= Prepare the Cursor Statement ==========
77: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
78: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
79: ELSE
80: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';
81: END IF;
82:
83: lv_cursor_stmt := 'SELECT'
84: ||' m1.INVENTORY_ITEM_ID ASSET_ACTIVITY_ID,'

Line 197: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

193: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
194: '========================================');
195: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
196: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
197: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
198: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
199: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
200: RAISE;
201: ELSE

Line 206: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

202: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
203: '========================================');
204: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
205: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
206: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
207: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
208: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
209: END IF;
210: END;

Line 218: DELETE MSC_EAM_ACT_ASSOCIATIONS

214:
215: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
216:
217: FOR c_rec IN c_del LOOP
218: DELETE MSC_EAM_ACT_ASSOCIATIONS
219: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
220: AND ASSET_ACTIVITY_ID = c_rec.asset_activity_id
221: AND ORGANIZATION_ID = c_rec.organization_id
222: AND ASSET_REBUILD_ITEM_ID = c_rec.asset_rebuild_item_id;

Line 241: UPDATE MSC_EAM_ACT_ASSOCIATIONS

237:
238: EXIT WHEN c4%NOTFOUND;
239:
240: BEGIN
241: UPDATE MSC_EAM_ACT_ASSOCIATIONS
242: SET ACTIVITY = lv_ACTIVITY,
243: ACTIVITY_TYPE =lv_ACTIVITY_TYPE,
244: ASSET_REBUILD_GROUP = lv_ASSET_REBUILD_GROUP,
245: EAM_ITEM_TYPE = lv_EAM_ITEM_TYPE,

Line 294: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

290: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
291: '========================================');
292: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
293: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
294: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
295: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
296: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
297: RAISE;
298:

Line 306: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

302: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,
303: '========================================');
304: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
305: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
306: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
307: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
308:
309: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
310: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');

Line 345: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ACT_ASSOCIATIONS'

341: AND (MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES)) THEN
342:
343: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
344: lv_sql_stmt:= 'INSERT INTO '||MSC_UTIL.G_MSC_SCHEMA||'.'||lv_tbl
345: ||' SELECT * from '||MSC_UTIL.G_MSC_SCHEMA||'.MSC_EAM_ACT_ASSOCIATIONS'
346: ||' WHERE sr_instance_id = '
347: ||MSC_CL_COLLECTION.v_instance_id
348: ||' AND organization_id not '||MSC_UTIL.v_in_org_str;
349:

Line 365: 'MSC_EAM_ACT_ASSOCIATIONS',

361:
362: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
363: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
364: lv_retcode,
365: 'MSC_EAM_ACT_ASSOCIATIONS',
366: MSC_CL_COLLECTION.v_instance_code,
367: MSC_UTIL.G_WARNING
368: );
369:

Line 756: DELETE MSC_EAM_ACT_ASSOCIATIONS

752:
753: /* FOR c_rec IN c_del LOOP
754: BEGIN
755:
756: DELETE MSC_EAM_ACT_ASSOCIATIONS
757: WHERE SR_INSTANCE_ID= c_rec.sr_instance_id
758: AND ASSET_ACTIVITY_ID = c_rec.asset_activity_id
759: AND ORGANIZATION_ID = c_rec.organization_id
760: AND ASSET_REBUILD_ITEM_ID = c_rec.asset_rebuild_item_id;

Line 778: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';

774: BEGIN
775: IF MSC_CL_COLLECTION.v_exchange_mode = MSC_UTIL.SYS_YES THEN
776: lv_tbl:= 'EAM_ACT_ASSOCIATIONS_'||MSC_CL_COLLECTION.v_instance_code;
777: ELSE
778: lv_tbl:= 'MSC_EAM_ACT_ASSOCIATIONS';
779: END IF;
780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,
781: 'In Procedure LOAD_EAM_INFO lv_tbl'||lv_tbl);
782:

Line 836: UPDATE MSC_EAM_ACT_ASSOCIATIONS

832:
833: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
834:
835: FOR c_rec IN c1 LOOP
836: UPDATE MSC_EAM_ACT_ASSOCIATIONS
837: SET
838: ACTIVITY = c_rec.ACTIVITY,
839: ACTIVITY_TYPE = c_rec.ACTIVITY_TYPE,
840: ASSET_REBUILD_GROUP = c_rec.ASSET_REBUILD_GROUP,

Line 882: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

878:
879: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
880: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
881: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
882: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
883: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
884:
885: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
886: RAISE;

Line 895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');

891:
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_EAM_INFO');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_EAM_ACT_ASSOCIATIONS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
899: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSET_ACTIVITY_ID');

Line 919: 'MSC_EAM_ACT_ASSOCIATIONS',

915:
916: IF MSC_CL_COLLECTION.v_exchange_mode=MSC_UTIL.SYS_YES THEN
917: MSC_CL_COLLECTION.alter_temp_table (lv_errbuf,
918: lv_retcode,
919: 'MSC_EAM_ACT_ASSOCIATIONS',
920: MSC_CL_COLLECTION.v_INSTANCE_CODE,
921: MSC_UTIL.G_ERROR);
922:
923: IF lv_retcode = MSC_UTIL.G_ERROR THEN

Line 1393: ||'MSC_EAM_ACT_ASSOCIATIONS mea '

1389: ||'b.REPAIRABLE, '
1390: ||'b.PLAN_ID, '
1391: ||'b.SR_INSTANCE_ID '
1392: ||'FROM MSC_BOMS b, '
1393: ||'MSC_EAM_ACT_ASSOCIATIONS mea '
1394: ||'WHERE b.ASSEMBLY_ITEM_ID = mea.ASSET_REBUILD_ITEM_ID '
1395: ||'AND b.ACTIVITY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1396: ||'AND b.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1397: ||'AND b.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '

Line 1472: ||'MSC_EAM_ACT_ASSOCIATIONS mea '

1468: ||':v_current_user, '
1469: ||':v_current_date, '
1470: ||':v_current_user '
1471: ||'FROM MSC_BOMS b, '
1472: ||'MSC_EAM_ACT_ASSOCIATIONS mea '
1473: ||'WHERE b.ASSEMBLY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1474: ||'AND b.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1475: ||'AND b.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1476: ||'AND b.PLAN_ID =-1 '

Line 1520: ||'MSC_EAM_ACT_ASSOCIATIONS mea '

1516: ||'mr.REPAIRABLE, '
1517: ||'mr.PLAN_ID, '
1518: ||'mr.SR_INSTANCE_ID '
1519: ||'FROM MSC_ROUTINGS mr, '
1520: ||'MSC_EAM_ACT_ASSOCIATIONS mea '
1521: ||'WHERE mr.ASSEMBLY_ITEM_ID = mea.ASSET_REBUILD_ITEM_ID '
1522: ||'AND mr.ACTIVITY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1523: ||'AND mr.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1524: ||'AND mr.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '

Line 1596: ||'MSC_EAM_ACT_ASSOCIATIONS mea '

1592: ||':v_current_user, '
1593: ||':v_current_date, '
1594: ||':v_current_user '
1595: ||'FROM MSC_ROUTINGS mr, '
1596: ||'MSC_EAM_ACT_ASSOCIATIONS mea '
1597: ||'WHERE mr.ASSEMBLY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1598: ||'AND mr.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1599: ||'AND mr.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1600: ||'AND mr.PLAN_ID =-1 '

Line 1647: ||'MSC_EAM_ACT_ASSOCIATIONS mea '

1643: ||'mpe.REPAIRABLE, '
1644: ||'mpe.PLAN_ID, '
1645: ||'mpe.SR_INSTANCE_ID '
1646: ||'FROM MSC_PROCESS_EFFECTIVITY mpe, '
1647: ||'MSC_EAM_ACT_ASSOCIATIONS mea '
1648: ||'WHERE mpe.ITEM_ID = mea.ASSET_REBUILD_ITEM_ID '
1649: ||'AND mpe.ACTIVITY_ITEM_ID = mea.ASSET_ACTIVITY_ID '
1650: ||'AND mpe.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1651: ||'AND mpe.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '

Line 1740: ||' MSC_EAM_ACT_ASSOCIATIONS mea '

1736: ||':v_current_user, '
1737: ||':v_current_date, '
1738: ||':v_current_user '
1739: ||' FROM MSC_PROCESS_EFFECTIVITY mpe, '
1740: ||' MSC_EAM_ACT_ASSOCIATIONS mea '
1741: ||' WHERE mpe.ITEM_ID = mea.ASSET_ACTIVITY_ID '
1742: ||' AND mpe.ORGANIZATION_ID = mea.ORGANIZATION_ID '
1743: ||' AND mpe.SR_INSTANCE_ID = mea.SR_INSTANCE_ID '
1744: ||' AND mpe.PLAN_ID =-1 '

Line 1784: msc_eam_act_associations mea

1780: cursor c_prod_stock is
1781: select s.inventory_item_id,s.asset_item_id,s.order_type,s.order_number,
1782: s.transaction_id,s.organization_id,s.activity_item_id
1783: from msc_supplies s,
1784: msc_eam_act_associations mea
1785: where s.asset_item_id = mea.asset_rebuild_item_id
1786: and s.inventory_item_id = mea.asset_rebuild_item_id
1787: and s.activity_item_id = mea.asset_activity_id
1788: and s.organization_id = mea.organization_id