APPS.MSC_CL_EAM_ODS_LOAD dependencies on MSC_PROCESS_EFFECTIVITY

Line 1646: ||'FROM MSC_PROCESS_EFFECTIVITY mpe, '

1642: ||'mpe.LINE_ID, '
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 '

Line 1673: UPDATE MSC_PROCESS_EFFECTIVITY

1669:
1670: EXIT WHEN c4%NOTFOUND;
1671:
1672:
1673: UPDATE MSC_PROCESS_EFFECTIVITY
1674: SET PROCESS_SEQUENCE_ID =lv_PROCESS_SEQUENCE_ID,
1675: ROUTING_SEQUENCE_ID = lv_ROUTING_SEQUENCE_ID,
1676: BILL_SEQUENCE_ID = lv_BILL_SEQUENCE_ID,
1677: ITEM_ID = lv_ASSET_REBUILD_ITEM_ID,

Line 1702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_PROCESS_EFFECTIVITY: count ' || cnt2);

1698: cnt2 := cnt2+1;
1699:
1700: END LOOP;
1701:
1702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_PROCESS_EFFECTIVITY: count ' || cnt2);
1703:
1704: lv_ins_stmt2 :=
1705: 'INSERT INTO MSC_PROCESS_EFFECTIVITY ( '
1706: ||'PROCESS_SEQUENCE_ID, '

Line 1705: 'INSERT INTO MSC_PROCESS_EFFECTIVITY ( '

1701:
1702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_PROCESS_EFFECTIVITY: count ' || cnt2);
1703:
1704: lv_ins_stmt2 :=
1705: 'INSERT INTO MSC_PROCESS_EFFECTIVITY ( '
1706: ||'PROCESS_SEQUENCE_ID, '
1707: ||'ROUTING_SEQUENCE_ID, '
1708: ||'BILL_SEQUENCE_ID, '
1709: ||'ITEM_ID, '

Line 1723: ||'MSC_PROCESS_EFFECTIVITY_S.NEXTVAL, '

1719: ||'LAST_UPDATED_BY, '
1720: ||'CREATION_DATE, '
1721: ||'CREATED_BY ) '
1722: ||'SELECT '
1723: ||'MSC_PROCESS_EFFECTIVITY_S.NEXTVAL, '
1724: ||'mpe.ROUTING_SEQUENCE_ID, '
1725: ||'mpe.BILL_SEQUENCE_ID, '
1726: ||'mea.ASSET_REBUILD_ITEM_ID, '
1727: ||'mea.ASSET_ACTIVITY_ID, '

Line 1739: ||' FROM MSC_PROCESS_EFFECTIVITY mpe, '

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

Line 1749: ||' from MSC_PROCESS_EFFECTIVITY where PLAN_ID =-1 '

1745: ||' AND mpe.SR_INSTANCE_ID = '|| MSC_CL_COLLECTION.v_instance_id
1746: ||' AND (mea.ASSET_REBUILD_ITEM_ID,mpe.ROUTING_SEQUENCE_ID,mpe.BILL_SEQUENCE_ID,mea.ASSET_ACTIVITY_ID,mpe.LINE_ID,mpe.ORGANIZATION_ID)'
1747: ||' not in '
1748: ||' (select ITEM_ID,ROUTING_SEQUENCE_ID,BILL_SEQUENCE_ID,ACTIVITY_ITEM_ID,LINE_ID,ORGANIZATION_ID '
1749: ||' from MSC_PROCESS_EFFECTIVITY where PLAN_ID =-1 '
1750: ||' AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';
1751:
1752:
1753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed--' || lv_ins_stmt2);