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_PURGE_LID dependencies on MSC_LOCAL_ID_SUPPLY

Line 539: FROM msc_local_id_supply lid

535: AND ms.sr_instance_id = lid.instance_id;
536:
537: CURSOR C5(p_instance_id NUMBER) IS
538: SELECT rowid
539: FROM msc_local_id_supply lid
540: WHERE lid.entity_name ='WIP_ENTITY_ID'
541: AND lid.instance_id = p_instance_id
542: MINUS
543: SELECT distinct lid.rowid

Line 544: FROM msc_local_id_supply lid, msc_supplies ms

540: WHERE lid.entity_name ='WIP_ENTITY_ID'
541: AND lid.instance_id = p_instance_id
542: MINUS
543: SELECT distinct lid.rowid
544: FROM msc_local_id_supply lid, msc_supplies ms
545: WHERE lid.instance_id = p_instance_id
546: AND lid.entity_name ='WIP_ENTITY_ID'
547: AND ms.disposition_id = lid.local_id
548: AND ms.order_type IN (3,7,27)

Line 554: FROM msc_local_id_supply lid

550: AND ms.sr_instance_id = lid.instance_id;
551:
552: CURSOR C6(p_instance_id NUMBER) IS
553: SELECT rowid
554: FROM msc_local_id_supply lid
555: WHERE lid.entity_name ='SR_MTL_SUPPLY_ID'
556: AND lid.instance_id = p_instance_id
557: MINUS
558: SELECT distinct lid.rowid

Line 559: FROM msc_local_id_supply lid, msc_supplies ms

555: WHERE lid.entity_name ='SR_MTL_SUPPLY_ID'
556: AND lid.instance_id = p_instance_id
557: MINUS
558: SELECT distinct lid.rowid
559: FROM msc_local_id_supply lid, msc_supplies ms
560: WHERE lid.instance_id = p_instance_id
561: AND lid.entity_name = 'SR_MTL_SUPPLY_ID'
562: AND ms.sr_mtl_supply_id = lid.local_id
563: AND ms.order_type IN (1,2,8,11,12)

Line 569: FROM msc_local_id_supply lid

565: AND ms.sr_instance_id = lid.instance_id;
566:
567: CURSOR C7(p_instance_id NUMBER) IS
568: SELECT rowid
569: FROM msc_local_id_supply lid
570: WHERE lid.entity_name ='PO_LINE_ID'
571: AND lid.instance_id = p_instance_id
572: MINUS
573: SELECT distinct lid.rowid

Line 574: FROM msc_local_id_supply lid, msc_supplies ms

570: WHERE lid.entity_name ='PO_LINE_ID'
571: AND lid.instance_id = p_instance_id
572: MINUS
573: SELECT distinct lid.rowid
574: FROM msc_local_id_supply lid, msc_supplies ms
575: WHERE lid.instance_id = p_instance_id
576: AND lid.entity_name = 'PO_LINE_ID'
577: AND ms.po_line_id = lid.local_id
578: AND ms.order_type IN (1,2,8,11,12)

Line 584: FROM msc_local_id_supply lid

580: AND ms.sr_instance_id = lid.instance_id;
581:
582: CURSOR C8(p_instance_id NUMBER) IS
583: SELECT rowid
584: FROM msc_local_id_supply lid
585: WHERE lid.entity_name ='DISPOSITION_ID'
586: AND lid.instance_id = p_instance_id
587: MINUS
588: SELECT distinct lid.rowid

Line 589: FROM msc_local_id_supply lid, msc_supplies ms

585: WHERE lid.entity_name ='DISPOSITION_ID'
586: AND lid.instance_id = p_instance_id
587: MINUS
588: SELECT distinct lid.rowid
589: FROM msc_local_id_supply lid, msc_supplies ms
590: WHERE lid.instance_id = p_instance_id
591: AND lid.entity_name = 'DISPOSITION_ID'
592: AND ms.disposition_id = lid.local_id
593: AND ms.order_type IN (1,2,8,11,12)

Line 599: FROM msc_local_id_supply lid

595: AND ms.sr_instance_id = lid.instance_id;
596:
597: CURSOR C9(p_instance_id NUMBER) IS
598: SELECT rowid
599: FROM msc_local_id_supply lid
600: WHERE lid.entity_name ='DISPOSITION_ID_MPS'
601: AND lid.instance_id = p_instance_id
602: MINUS
603: SELECT distinct lid.rowid

Line 604: FROM msc_local_id_supply lid, msc_supplies ms

600: WHERE lid.entity_name ='DISPOSITION_ID_MPS'
601: AND lid.instance_id = p_instance_id
602: MINUS
603: SELECT distinct lid.rowid
604: FROM msc_local_id_supply lid, msc_supplies ms
605: WHERE lid.instance_id = p_instance_id
606: AND lid.entity_name = 'DISPOSITION_ID_MPS'
607: AND ms.disposition_id = lid.local_id
608: AND ms.order_type = 5

Line 614: FROM msc_local_id_supply lid

610: AND ms.sr_instance_id = lid.instance_id;
611:
612: CURSOR C10(p_instance_id NUMBER) IS
613: SELECT rowid
614: FROM msc_local_id_supply lid
615: WHERE lid.entity_name ='SCHEDULE_GROUP_ID'
616: AND lid.instance_id = p_instance_id
617: MINUS
618: SELECT distinct lid. rowid

Line 619: FROM msc_local_id_supply lid, msc_supplies ms

615: WHERE lid.entity_name ='SCHEDULE_GROUP_ID'
616: AND lid.instance_id = p_instance_id
617: MINUS
618: SELECT distinct lid. rowid
619: FROM msc_local_id_supply lid, msc_supplies ms
620: WHERE lid.instance_id = p_instance_id
621: AND lid.entity_name = 'SCHEDULE_GROUP_ID'
622: AND ms.schedule_group_id = lid.local_id
623: AND ms.plan_id = -1

Line 973: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

969:
970: DELETE_MSC_TABLE( 'MSC_SUPPLIES', v_instance_id, -1);
971:
972: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID',
973: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
974: p_instance_id => v_instance_id,
975: p_where_str => NULL );
976:
977: DELETE_LID_TABLE( p_entity_name => 'PO_LINE_ID',

Line 978: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

974: p_instance_id => v_instance_id,
975: p_where_str => NULL );
976:
977: DELETE_LID_TABLE( p_entity_name => 'PO_LINE_ID',
978: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
979: p_instance_id => v_instance_id,
980: p_where_str => NULL );
981:
982: DELETE_LID_TABLE( p_entity_name => 'SCHEDULE_GROUP_ID',

Line 983: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

979: p_instance_id => v_instance_id,
980: p_where_str => NULL );
981:
982: DELETE_LID_TABLE( p_entity_name => 'SCHEDULE_GROUP_ID',
983: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
984: p_instance_id => v_instance_id,
985: p_where_str => NULL );
986:
987: DELETE_LID_TABLE( p_entity_name => 'DISPOSTION_ID_MPS',

Line 988: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

984: p_instance_id => v_instance_id,
985: p_where_str => NULL );
986:
987: DELETE_LID_TABLE( p_entity_name => 'DISPOSTION_ID_MPS',
988: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
989: p_instance_id => v_instance_id,
990: p_where_str => NULL );
991:
992: DELETE_LID_TABLE( p_entity_name => 'SR_MTL_SUPPLY_ID',

Line 993: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

989: p_instance_id => v_instance_id,
990: p_where_str => NULL );
991:
992: DELETE_LID_TABLE( p_entity_name => 'SR_MTL_SUPPLY_ID',
993: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
994: p_instance_id => v_instance_id,
995: p_where_str => NULL );
996:
997: DELETE_LID_TABLE( p_entity_name => 'WIP_ENTITY_ID',

Line 998: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

994: p_instance_id => v_instance_id,
995: p_where_str => NULL );
996:
997: DELETE_LID_TABLE( p_entity_name => 'WIP_ENTITY_ID',
998: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
999: p_instance_id => v_instance_id,
1000: p_where_str => NULL );
1001:
1002: -------- Delete OSFM tables ---------------------------

Line 1199: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_IDstarts here --

1195: p_plan_id => -1,
1196: p_sub_str => ' and trunc(NEW_SCHEDULE_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1197:
1198:
1199: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_IDstarts here --
1200:
1201: lv_task_start_time:= SYSDATE;
1202: lv_total := 0;
1203: v_sql_stmt := 05;

Line 1205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID');

1201: lv_task_start_time:= SYSDATE;
1202: lv_total := 0;
1203: v_sql_stmt := 05;
1204:
1205: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID');
1206:
1207: OPEN C5(v_instance_id);
1208:
1209: FETCH C5 BULK COLLECT INTO lb_rowid ;

Line 1214: DELETE FROM MSC_LOCAL_ID_SUPPLY

1210: IF C5%ROWCOUNT > 0 THEN
1211:
1212: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1213:
1214: DELETE FROM MSC_LOCAL_ID_SUPPLY
1215: WHERE ROWID = lb_rowid(j);
1216:
1217: lv_total := C5%ROWCOUNT;
1218:

Line 1232: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----

1228: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1229: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
1231:
1232: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----
1233:
1234:
1235: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID starts here --
1236:

Line 1235: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID starts here --

1231:
1232: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----
1233:
1234:
1235: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID starts here --
1236:
1237: lv_task_start_time:= SYSDATE;
1238: lv_total := 0;
1239: v_sql_stmt := 06;

Line 1241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID');

1237: lv_task_start_time:= SYSDATE;
1238: lv_total := 0;
1239: v_sql_stmt := 06;
1240:
1241: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID');
1242:
1243:
1244: OPEN C6(v_instance_id);
1245:

Line 1252: DELETE FROM MSC_LOCAL_ID_SUPPLY

1248: IF C6%ROWCOUNT > 0 THEN
1249:
1250: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1251:
1252: DELETE FROM MSC_LOCAL_ID_SUPPLY
1253: WHERE ROWID = lb_rowid(j);
1254:
1255: lv_total := C6%ROWCOUNT;
1256:

Line 1270: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----

1266: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1267: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1268: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1269:
1270: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1271:
1272:
1273: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID starts here --
1274:

Line 1273: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID starts here --

1269:
1270: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1271:
1272:
1273: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID starts here --
1274:
1275: lv_task_start_time:= SYSDATE;
1276: lv_total := 0;
1277: v_sql_stmt := 07;

Line 1279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID');

1275: lv_task_start_time:= SYSDATE;
1276: lv_total := 0;
1277: v_sql_stmt := 07;
1278:
1279: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID');
1280:
1281: OPEN C7(v_instance_id);
1282:
1283: FETCH C7 BULK COLLECT INTO lb_rowid ;

Line 1289: DELETE FROM MSC_LOCAL_ID_SUPPLY

1285: IF C7%ROWCOUNT > 0 THEN
1286:
1287: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1288:
1289: DELETE FROM MSC_LOCAL_ID_SUPPLY
1290: WHERE ROWID = lb_rowid(j);
1291:
1292: lv_total := C7%ROWCOUNT;
1293:

Line 1307: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----

1303: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1304: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1306:
1307: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1308:
1309: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID starts here --
1310:
1311: lv_task_start_time:= SYSDATE;

Line 1309: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID starts here --

1305: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1306:
1307: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1308:
1309: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID starts here --
1310:
1311: lv_task_start_time:= SYSDATE;
1312: lv_total := 0;
1313: v_sql_stmt := 08;

Line 1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID');

1311: lv_task_start_time:= SYSDATE;
1312: lv_total := 0;
1313: v_sql_stmt := 08;
1314:
1315: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID');
1316:
1317:
1318: OPEN C8(v_instance_id);
1319:

Line 1326: DELETE FROM MSC_LOCAL_ID_SUPPLY

1322: IF C8%ROWCOUNT > 0 THEN
1323:
1324: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1325:
1326: DELETE FROM MSC_LOCAL_ID_SUPPLY
1327: WHERE ROWID = lb_rowid(j);
1328:
1329: lv_total := C8%ROWCOUNT;
1330:

Line 1344: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----

1340: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1341: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1342: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1343:
1344: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----
1345:
1346:
1347: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS starts here --
1348:

Line 1347: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS starts here --

1343:
1344: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----
1345:
1346:
1347: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS starts here --
1348:
1349: lv_task_start_time:= SYSDATE;
1350: lv_total := 0;
1351: v_sql_stmt := 09;

Line 1353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS');

1349: lv_task_start_time:= SYSDATE;
1350: lv_total := 0;
1351: v_sql_stmt := 09;
1352:
1353: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS');
1354:
1355:
1356: OPEN C9(v_instance_id);
1357:

Line 1364: DELETE FROM MSC_LOCAL_ID_SUPPLY

1360: IF C9%ROWCOUNT > 0 THEN
1361:
1362: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1363:
1364: DELETE FROM MSC_LOCAL_ID_SUPPLY
1365: WHERE ROWID = lb_rowid(j);
1366:
1367: lv_total := C9%ROWCOUNT;
1368:

Line 1382: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----

1378: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1379: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1381:
1382: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1383:
1384:
1385: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID starts here --
1386:

Line 1385: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID starts here --

1381:
1382: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1383:
1384:
1385: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID starts here --
1386:
1387: lv_task_start_time:= SYSDATE;
1388: lv_total := 0;
1389: v_sql_stmt := 10;

Line 1391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID');

1387: lv_task_start_time:= SYSDATE;
1388: lv_total := 0;
1389: v_sql_stmt := 10;
1390:
1391: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID');
1392:
1393:
1394: OPEN C10(v_instance_id);
1395:

Line 1402: DELETE FROM MSC_LOCAL_ID_SUPPLY

1398: IF C10%ROWCOUNT > 0 THEN
1399:
1400: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1401:
1402: DELETE FROM MSC_LOCAL_ID_SUPPLY
1403: WHERE ROWID = lb_rowid(j);
1404:
1405: lv_total := C10%ROWCOUNT;
1406:

Line 1420: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----

1416: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1417: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1418: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1419:
1420: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----
1421: END IF ; -- p_suply_flag
1422: END IF ; -- Complete refresh
1423:
1424: --------- Till here modified for the bug fix 2229944 --------------