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 521: FROM msc_local_id_supply lid

517: AND ms.sr_instance_id = lid.instance_id;
518:
519: CURSOR C5(p_instance_id NUMBER) IS
520: SELECT rowid
521: FROM msc_local_id_supply lid
522: WHERE lid.entity_name ='WIP_ENTITY_ID'
523: AND lid.instance_id = p_instance_id
524: MINUS
525: SELECT distinct lid.rowid

Line 526: FROM msc_local_id_supply lid, msc_supplies ms

522: WHERE lid.entity_name ='WIP_ENTITY_ID'
523: AND lid.instance_id = p_instance_id
524: MINUS
525: SELECT distinct lid.rowid
526: FROM msc_local_id_supply lid, msc_supplies ms
527: WHERE lid.instance_id = p_instance_id
528: AND lid.entity_name ='WIP_ENTITY_ID'
529: AND ms.disposition_id = lid.local_id
530: AND ms.order_type IN (3,7,27)

Line 536: FROM msc_local_id_supply lid

532: AND ms.sr_instance_id = lid.instance_id;
533:
534: CURSOR C6(p_instance_id NUMBER) IS
535: SELECT rowid
536: FROM msc_local_id_supply lid
537: WHERE lid.entity_name ='SR_MTL_SUPPLY_ID'
538: AND lid.instance_id = p_instance_id
539: MINUS
540: SELECT distinct lid.rowid

Line 541: FROM msc_local_id_supply lid, msc_supplies ms

537: WHERE lid.entity_name ='SR_MTL_SUPPLY_ID'
538: AND lid.instance_id = p_instance_id
539: MINUS
540: SELECT distinct lid.rowid
541: FROM msc_local_id_supply lid, msc_supplies ms
542: WHERE lid.instance_id = p_instance_id
543: AND lid.entity_name = 'SR_MTL_SUPPLY_ID'
544: AND ms.sr_mtl_supply_id = lid.local_id
545: AND ms.order_type IN (1,2,8,11,12)

Line 551: FROM msc_local_id_supply lid

547: AND ms.sr_instance_id = lid.instance_id;
548:
549: CURSOR C7(p_instance_id NUMBER) IS
550: SELECT rowid
551: FROM msc_local_id_supply lid
552: WHERE lid.entity_name ='PO_LINE_ID'
553: AND lid.instance_id = p_instance_id
554: MINUS
555: SELECT distinct lid.rowid

Line 556: FROM msc_local_id_supply lid, msc_supplies ms

552: WHERE lid.entity_name ='PO_LINE_ID'
553: AND lid.instance_id = p_instance_id
554: MINUS
555: SELECT distinct lid.rowid
556: FROM msc_local_id_supply lid, msc_supplies ms
557: WHERE lid.instance_id = p_instance_id
558: AND lid.entity_name = 'PO_LINE_ID'
559: AND ms.po_line_id = lid.local_id
560: AND ms.order_type IN (1,2,8,11,12)

Line 566: FROM msc_local_id_supply lid

562: AND ms.sr_instance_id = lid.instance_id;
563:
564: CURSOR C8(p_instance_id NUMBER) IS
565: SELECT rowid
566: FROM msc_local_id_supply lid
567: WHERE lid.entity_name ='DISPOSITION_ID'
568: AND lid.instance_id = p_instance_id
569: MINUS
570: SELECT distinct lid.rowid

Line 571: FROM msc_local_id_supply lid, msc_supplies ms

567: WHERE lid.entity_name ='DISPOSITION_ID'
568: AND lid.instance_id = p_instance_id
569: MINUS
570: SELECT distinct lid.rowid
571: FROM msc_local_id_supply lid, msc_supplies ms
572: WHERE lid.instance_id = p_instance_id
573: AND lid.entity_name = 'DISPOSITION_ID'
574: AND ms.disposition_id = lid.local_id
575: AND ms.order_type IN (1,2,8,11,12)

Line 581: FROM msc_local_id_supply lid

577: AND ms.sr_instance_id = lid.instance_id;
578:
579: CURSOR C9(p_instance_id NUMBER) IS
580: SELECT rowid
581: FROM msc_local_id_supply lid
582: WHERE lid.entity_name ='DISPOSITION_ID_MPS'
583: AND lid.instance_id = p_instance_id
584: MINUS
585: SELECT distinct lid.rowid

Line 586: FROM msc_local_id_supply lid, msc_supplies ms

582: WHERE lid.entity_name ='DISPOSITION_ID_MPS'
583: AND lid.instance_id = p_instance_id
584: MINUS
585: SELECT distinct lid.rowid
586: FROM msc_local_id_supply lid, msc_supplies ms
587: WHERE lid.instance_id = p_instance_id
588: AND lid.entity_name = 'DISPOSITION_ID_MPS'
589: AND ms.disposition_id = lid.local_id
590: AND ms.order_type = 5

Line 596: FROM msc_local_id_supply lid

592: AND ms.sr_instance_id = lid.instance_id;
593:
594: CURSOR C10(p_instance_id NUMBER) IS
595: SELECT rowid
596: FROM msc_local_id_supply lid
597: WHERE lid.entity_name ='SCHEDULE_GROUP_ID'
598: AND lid.instance_id = p_instance_id
599: MINUS
600: SELECT distinct lid. rowid

Line 601: FROM msc_local_id_supply lid, msc_supplies ms

597: WHERE lid.entity_name ='SCHEDULE_GROUP_ID'
598: AND lid.instance_id = p_instance_id
599: MINUS
600: SELECT distinct lid. rowid
601: FROM msc_local_id_supply lid, msc_supplies ms
602: WHERE lid.instance_id = p_instance_id
603: AND lid.entity_name = 'SCHEDULE_GROUP_ID'
604: AND ms.schedule_group_id = lid.local_id
605: AND ms.plan_id = -1

Line 960: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

956:
957: DELETE_MSC_TABLE( 'MSC_SUPPLIES', v_instance_id, -1);
958:
959: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID',
960: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
961: p_instance_id => v_instance_id,
962: p_where_str => NULL );
963:
964: DELETE_LID_TABLE( p_entity_name => 'PO_LINE_ID',

Line 965: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

961: p_instance_id => v_instance_id,
962: p_where_str => NULL );
963:
964: DELETE_LID_TABLE( p_entity_name => 'PO_LINE_ID',
965: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
966: p_instance_id => v_instance_id,
967: p_where_str => NULL );
968:
969: DELETE_LID_TABLE( p_entity_name => 'SCHEDULE_GROUP_ID',

Line 970: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

966: p_instance_id => v_instance_id,
967: p_where_str => NULL );
968:
969: DELETE_LID_TABLE( p_entity_name => 'SCHEDULE_GROUP_ID',
970: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
971: p_instance_id => v_instance_id,
972: p_where_str => NULL );
973:
974: DELETE_LID_TABLE( p_entity_name => 'DISPOSTION_ID_MPS',

Line 975: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

971: p_instance_id => v_instance_id,
972: p_where_str => NULL );
973:
974: DELETE_LID_TABLE( p_entity_name => 'DISPOSTION_ID_MPS',
975: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
976: p_instance_id => v_instance_id,
977: p_where_str => NULL );
978:
979: DELETE_LID_TABLE( p_entity_name => 'SR_MTL_SUPPLY_ID',

Line 980: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

976: p_instance_id => v_instance_id,
977: p_where_str => NULL );
978:
979: DELETE_LID_TABLE( p_entity_name => 'SR_MTL_SUPPLY_ID',
980: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
981: p_instance_id => v_instance_id,
982: p_where_str => NULL );
983:
984: DELETE_LID_TABLE( p_entity_name => 'WIP_ENTITY_ID',

Line 985: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',

981: p_instance_id => v_instance_id,
982: p_where_str => NULL );
983:
984: DELETE_LID_TABLE( p_entity_name => 'WIP_ENTITY_ID',
985: p_lid_table => 'MSC_LOCAL_ID_SUPPLY',
986: p_instance_id => v_instance_id,
987: p_where_str => NULL );
988:
989: -------- Delete OSFM tables ---------------------------

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

1237: p_plan_id => -1,
1238: p_sub_str => ' and trunc(NEW_SCHEDULE_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1239:
1240:
1241: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_IDstarts here --
1242:
1243: lv_task_start_time:= SYSDATE;
1244: lv_total := 0;
1245: v_sql_stmt := 06;

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

1243: lv_task_start_time:= SYSDATE;
1244: lv_total := 0;
1245: v_sql_stmt := 06;
1246:
1247: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID');
1248:
1249: OPEN C5(v_instance_id);
1250:
1251: FETCH C5 BULK COLLECT INTO lb_rowid ;

Line 1256: DELETE FROM MSC_LOCAL_ID_SUPPLY

1252: IF C5%ROWCOUNT > 0 THEN
1253:
1254: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1255:
1256: DELETE FROM MSC_LOCAL_ID_SUPPLY
1257: WHERE ROWID = lb_rowid(j);
1258:
1259: lv_total := C5%ROWCOUNT;
1260:

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

1270: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1271: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1272: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,' '||FND_MESSAGE.GET);
1273:
1274: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----
1275:
1276:
1277: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID starts here --
1278:

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

1273:
1274: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name WIP_ENTITY_ID ends here ----
1275:
1276:
1277: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID starts here --
1278:
1279: lv_task_start_time:= SYSDATE;
1280: lv_total := 0;
1281: v_sql_stmt := 07;

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

1279: lv_task_start_time:= SYSDATE;
1280: lv_total := 0;
1281: v_sql_stmt := 07;
1282:
1283: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID');
1284:
1285:
1286: OPEN C6(v_instance_id);
1287:

Line 1294: DELETE FROM MSC_LOCAL_ID_SUPPLY

1290: IF C6%ROWCOUNT > 0 THEN
1291:
1292: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1293:
1294: DELETE FROM MSC_LOCAL_ID_SUPPLY
1295: WHERE ROWID = lb_rowid(j);
1296:
1297: lv_total := C6%ROWCOUNT;
1298:

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

1308: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1309: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1310: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1311:
1312: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1313:
1314:
1315: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID starts here --
1316:

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

1311:
1312: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SR_MTL_SUPPLY_ID ends here ----
1313:
1314:
1315: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID starts here --
1316:
1317: lv_task_start_time:= SYSDATE;
1318: lv_total := 0;
1319: v_sql_stmt := 08;

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

1317: lv_task_start_time:= SYSDATE;
1318: lv_total := 0;
1319: v_sql_stmt := 08;
1320:
1321: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID');
1322:
1323: OPEN C7(v_instance_id);
1324:
1325: FETCH C7 BULK COLLECT INTO lb_rowid ;

Line 1331: DELETE FROM MSC_LOCAL_ID_SUPPLY

1327: IF C7%ROWCOUNT > 0 THEN
1328:
1329: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1330:
1331: DELETE FROM MSC_LOCAL_ID_SUPPLY
1332: WHERE ROWID = lb_rowid(j);
1333:
1334: lv_total := C7%ROWCOUNT;
1335:

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

1345: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1346: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1348:
1349: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1350:
1351: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID starts here --
1352:
1353: lv_task_start_time:= SYSDATE;

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

1347: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1348:
1349: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name PO_LINE_ID ends here ----
1350:
1351: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID starts here --
1352:
1353: lv_task_start_time:= SYSDATE;
1354: lv_total := 0;
1355: v_sql_stmt := 09;

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

1353: lv_task_start_time:= SYSDATE;
1354: lv_total := 0;
1355: v_sql_stmt := 09;
1356:
1357: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID');
1358:
1359:
1360: OPEN C8(v_instance_id);
1361:

Line 1368: DELETE FROM MSC_LOCAL_ID_SUPPLY

1364: IF C8%ROWCOUNT > 0 THEN
1365:
1366: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1367:
1368: DELETE FROM MSC_LOCAL_ID_SUPPLY
1369: WHERE ROWID = lb_rowid(j);
1370:
1371: lv_total := C8%ROWCOUNT;
1372:

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

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

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

1385:
1386: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID ends here ----
1387:
1388:
1389: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS starts here --
1390:
1391: lv_task_start_time:= SYSDATE;
1392: lv_total := 0;
1393: v_sql_stmt := 10;

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

1391: lv_task_start_time:= SYSDATE;
1392: lv_total := 0;
1393: v_sql_stmt := 10;
1394:
1395: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS');
1396:
1397:
1398: OPEN C9(v_instance_id);
1399:

Line 1406: DELETE FROM MSC_LOCAL_ID_SUPPLY

1402: IF C9%ROWCOUNT > 0 THEN
1403:
1404: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1405:
1406: DELETE FROM MSC_LOCAL_ID_SUPPLY
1407: WHERE ROWID = lb_rowid(j);
1408:
1409: lv_total := C9%ROWCOUNT;
1410:

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

1420: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1421: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1422: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1423:
1424: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1425:
1426:
1427: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID starts here --
1428:

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

1423:
1424: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name DISPOSITION_ID_MPS ends here ----
1425:
1426:
1427: -- Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID starts here --
1428:
1429: lv_task_start_time:= SYSDATE;
1430: lv_total := 0;
1431: v_sql_stmt := 11;

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

1429: lv_task_start_time:= SYSDATE;
1430: lv_total := 0;
1431: v_sql_stmt := 11;
1432:
1433: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID');
1434:
1435:
1436: OPEN C10(v_instance_id);
1437:

Line 1444: DELETE FROM MSC_LOCAL_ID_SUPPLY

1440: IF C10%ROWCOUNT > 0 THEN
1441:
1442: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1443:
1444: DELETE FROM MSC_LOCAL_ID_SUPPLY
1445: WHERE ROWID = lb_rowid(j);
1446:
1447: lv_total := C10%ROWCOUNT;
1448:

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

1458: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1459: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1460: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1461:
1462: -- Deletion from MSC_LOCAL_ID_SUPPLY for entity_name SCHEDULE_GROUP_ID ends here ----
1463: END IF ; -- p_suply_flag
1464: END IF ; -- Complete refresh
1465:
1466: --------- Till here modified for the bug fix 2229944 --------------