APPS.MSC_PURGE_LID dependencies on MSC_SUPPLIES

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 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 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 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 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 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 970: DELETE_MSC_TABLE( 'MSC_SUPPLIES', v_instance_id, -1);

966: p_where_str => NULL );
967:
968: -----------------------DELETE 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,

Line 1193: DELETE_MSC_TABLE( p_table_name =>'MSC_SUPPLIES',

1189: END IF; -- p_demand_flag
1190:
1191:
1192: IF p_supply_flag = SYS_YES THEN
1193: DELETE_MSC_TABLE( p_table_name =>'MSC_SUPPLIES',
1194: p_instance_id => v_instance_id,
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:

Line 1564: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', p_instance_id, NULL);

1560: COMMIT;
1561: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', p_instance_id, NULL);
1562: COMMIT;
1563: ---------------- SUPPLY -------------
1564: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIES', p_instance_id, NULL);
1565: COMMIT;
1566: ---------------- RESOURCE REQUIREMENT -------------
1567: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESOURCE_REQUIREMENTS', p_instance_id, NULL);
1568: COMMIT;