[Home] [Help]
514: WHERE lid.entity_name ='SALES_ORDER_ID'
515: AND lid.instance_id = p_instance_id
516: MINUS
517: SELECT distinct lid.rowid
518: FROM msc_local_id_demand lid, msc_sales_orders ms
519: WHERE lid.instance_id = p_instance_id
520: AND lid.entity_name = 'SALES_ORDER_ID'
521: AND ms.demand_source_header_id = lid.local_id
522: AND ms.sr_instance_id = lid.instance_id;
527: WHERE lid.entity_name ='DEMAND_ID'
528: AND lid.instance_id = p_instance_id
529: MINUS
530: SELECT distinct lid.rowid
531: FROM msc_local_id_demand lid, msc_sales_orders ms
532: WHERE lid.instance_id = p_instance_id
533: AND lid.entity_name = 'DEMAND_ID'
534: AND ms.demand_id = lid.local_id
535: AND ms.sr_instance_id = lid.instance_id;
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',
944: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
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:
1029:
1030: DELETE_MSC_TABLE( p_table_name =>'MSC_SALES_ORDERS',
1031: p_instance_id => v_instance_id,
1032: p_plan_id => NULL,
1033: p_sub_str => ' and trunc(REQUIREMENT_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1034:
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;
1518: ---------------- HARD RESERVATION -------------
1519: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', p_instance_id, NULL);
1520: COMMIT;