[Home] [Help]
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)
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)
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)
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)
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
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
607:
608: -- till here added for the deletion of lid tables ( for the bug fix 2229944) --
609: CURSOR C11(p_instance_id NUMBER) IS
610: SELECT transaction_id
611: FROM msc_supplies ms
612: WHERE ms.sr_instance_id=p_instance_id
613: AND ms.plan_id = -1 and trunc(NEW_SCHEDULE_DATE) <=
614: trunc(to_date(p_date,'YYYY/MM/DD HH24:MI:SS'));
615:
953: p_where_str => NULL );
954:
955: -----------------------DELETE 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,
1231: MSC_ST_UTIL.LOG_MESSAGE(' '||FND_MESSAGE.GET);
1232:
1233:
1234:
1235: DELETE_MSC_TABLE( p_table_name =>'MSC_SUPPLIES',
1236: p_instance_id => v_instance_id,
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:
1602: COMMIT;
1603: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', p_instance_id, NULL);
1604: COMMIT;
1605: ---------------- SUPPLY -------------
1606: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', p_instance_id, NULL);
1607: COMMIT;
1608: ---------------- RESOURCE REQUIREMENT -------------
1609: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', p_instance_id, NULL);
1610: COMMIT;