APPS.MSC_CL_EAM_ODS_LOAD dependencies on MSC_BOMS

Line 1392: ||'FROM MSC_BOMS b, '

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

Line 1419: UPDATE MSC_BOMS

1415:
1416: EXIT WHEN c4%NOTFOUND;
1417:
1418:
1419: UPDATE MSC_BOMS
1420: SET BILL_SEQUENCE_ID = lv_BILL_SEQUENCE_ID,
1421: ASSEMBLY_TYPE =lv_ASSEMBLY_TYPE,
1422: ASSEMBLY_ITEM_ID = lv_ASSET_REBUILD_ITEM_ID,
1423: ORGANIZATION_ID = lv_ORGANIZATION_ID,

Line 1440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_BOMS: count ' || cnt);

1436:
1437: cnt := cnt+1;
1438: END LOOP;
1439:
1440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_BOMS: count ' || cnt);
1441:
1442: lv_ins_stmt :=
1443: 'INSERT INTO MSC_BOMS ( '
1444: ||'BILL_SEQUENCE_ID, '

Line 1443: 'INSERT INTO MSC_BOMS ( '

1439:
1440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'after update of MSC_BOMS: count ' || cnt);
1441:
1442: lv_ins_stmt :=
1443: 'INSERT INTO MSC_BOMS ( '
1444: ||'BILL_SEQUENCE_ID, '
1445: ||'ASSEMBLY_TYPE, '
1446: ||'ASSEMBLY_ITEM_ID, '
1447: ||'ORGANIZATION_ID, '

Line 1471: ||'FROM MSC_BOMS b, '

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

Line 1481: ||'from MSC_BOMS where PLAN_ID =-1 '

1477: ||'AND b.SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id
1478: ||' and (b.BILL_SEQUENCE_ID,mea.ASSET_REBUILD_ITEM_ID,mea.ASSET_ACTIVITY_ID,b.ORGANIZATION_ID) '
1479: ||' not in '
1480: ||'(select BILL_SEQUENCE_ID,ASSEMBLY_ITEM_ID,ACTIVITY_ITEM_ID,ORGANIZATION_ID '
1481: ||'from MSC_BOMS where PLAN_ID =-1 '
1482: ||' AND SR_INSTANCE_ID = ' || MSC_CL_COLLECTION.v_instance_id ||') ';
1483:
1484: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'stmt being executed-- ' || lv_ins_stmt);
1485:

Line 1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_boms '

1487: MSC_CL_COLLECTION.v_current_date,
1488: MSC_CL_COLLECTION.v_current_user,
1489: MSC_CL_COLLECTION.v_current_date,
1490: MSC_CL_COLLECTION.v_current_user;
1491: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'rows inserted into msc_boms '
1492: ||SQL%ROWCOUNT);
1493: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, '==========================================================');
1494:
1495: COMMIT;