[Home] [Help]
484: WHERE lid.entity_name ='DISPOSITION_ID_FCT'
485: AND lid.instance_id = p_instance_id
486: MINUS
487: SELECT distinct lid.rowid
488: FROM msc_local_id_demand lid, msc_demands ms
489: WHERE lid.instance_id = p_instance_id
490: AND lid.entity_name = 'DISPOSITION_ID_FCT'
491: AND ms.sales_order_line_id = lid.local_id
492: AND ms.plan_id = -1
499: WHERE lid.entity_name ='DISPOSITION_ID_MDS'
500: AND lid.instance_id = p_instance_id
501: MINUS
502: SELECT distinct lid.rowid
503: FROM msc_local_id_demand lid, msc_demands ms
504: WHERE lid.instance_id = p_instance_id
505: AND lid.entity_name = 'DISPOSITION_ID_MDS'
506: AND ms.disposition_id = lid.local_id
507: AND ms.origination_type = 8
935: -----------------------DELETE Hard Reservations-----------------------
936: DELETE_MSC_TABLE( 'MSC_RESERVATIONS', v_instance_id, -1);
937:
938: -----------------------DELETE Demand----------------------------
939: DELETE_MSC_TABLE( 'MSC_DEMANDS', v_instance_id, -1 );
940: DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', v_instance_id, NULL);
941:
942:
943: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',
1020:
1021:
1022: IF p_demand_flag = SYS_YES THEN
1023:
1024: DELETE_MSC_TABLE( p_table_name =>'MSC_DEMANDS',
1025: p_instance_id => v_instance_id,
1026: p_plan_id => -1,
1027: p_sub_str => ' and trunc(USING_ASSEMBLY_DEMAND_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1028:
1509: COMMIT;
1510: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CATEGORY_SETS', p_instance_id, NULL);
1511: COMMIT;
1512: ---------------- DEMAND -------------
1513: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEMANDS', p_instance_id, NULL);
1514: COMMIT;
1515: ---------------- SALES ORDER -------------
1516: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', p_instance_id, NULL);
1517: COMMIT;