APPS.MSC_CL_EAM_ODS_LOAD dependencies on MSC_ROUTINGS

Line 1519: ||'FROM MSC_ROUTINGS mr, '

1515: ||'mea.ASSET_ACTIVITY_ID, '
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 '

Line 1544: UPDATE MSC_ROUTINGS

1540:
1541: EXIT WHEN c4%NOTFOUND;
1542:
1543:
1544: UPDATE MSC_ROUTINGS
1545: SET ROUTING_SEQUENCE_ID = lv_ROUTING_SEQUENCE_ID,
1546: ASSEMBLY_ITEM_ID = lv_ASSET_REBUILD_ITEM_ID,
1547: ACTIVITY_ITEM_ID = lv_ASSET_ACTIVITY_ID,
1548: ROUTING_TYPE =lv_ROUTING_TYPE,

Line 1564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_ROUTINGS: count ' || cnt1);

1560: cnt1 := cnt1+1;
1561:
1562: END LOOP;
1563:
1564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_ROUTINGS: count ' || cnt1);
1565:
1566: lv_ins_stmt1 :=
1567: 'INSERT INTO MSC_ROUTINGS ( '
1568: ||'ROUTING_SEQUENCE_ID, '

Line 1567: 'INSERT INTO MSC_ROUTINGS ( '

1563:
1564: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_ROUTINGS: count ' || cnt1);
1565:
1566: lv_ins_stmt1 :=
1567: 'INSERT INTO MSC_ROUTINGS ( '
1568: ||'ROUTING_SEQUENCE_ID, '
1569: ||'ROUTING_TYPE, '
1570: ||'ASSEMBLY_ITEM_ID, '
1571: ||'ORGANIZATION_ID, '

Line 1595: ||'FROM MSC_ROUTINGS mr, '

1591: ||':v_current_date, '
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 '

Line 1605: ||'from MSC_ROUTINGS where PLAN_ID =-1 '

1601: ||'AND mr.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id
1602: ||' AND (mr.ROUTING_SEQUENCE_ID,mea.ASSET_REBUILD_ITEM_ID,mea.ASSET_ACTIVITY_ID,mr.ORGANIZATION_ID)'
1603: ||' not in '
1604: ||'(select ROUTING_SEQUENCE_ID, ASSEMBLY_ITEM_ID,ASSET_ACTIVITY_ID,ORGANIZATION_ID '
1605: ||'from MSC_ROUTINGS where PLAN_ID =-1 '
1606: ||'AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';
1607:
1608:
1609: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt1);

Line 1616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_routings'

1612: MSC_CL_COLLECTION.v_current_date,
1613: MSC_CL_COLLECTION.v_current_user,
1614: MSC_CL_COLLECTION.v_current_date,
1615: MSC_CL_COLLECTION.v_current_user;
1616: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_routings'
1617: ||SQL%ROWCOUNT);
1618: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
1619:
1620: COMMIT;