[Home] [Help]
496: WHERE lid.entity_name ='SALES_ORDER_ID'
497: AND lid.instance_id = p_instance_id
498: MINUS
499: SELECT distinct lid.rowid
500: FROM msc_local_id_demand lid, msc_sales_orders ms
501: WHERE lid.instance_id = p_instance_id
502: AND lid.entity_name = 'SALES_ORDER_ID'
503: AND ms.demand_source_header_id = lid.local_id
504: AND ms.sr_instance_id = lid.instance_id;
509: WHERE lid.entity_name ='DEMAND_ID'
510: AND lid.instance_id = p_instance_id
511: MINUS
512: SELECT distinct lid.rowid
513: FROM msc_local_id_demand lid, msc_sales_orders ms
514: WHERE lid.instance_id = p_instance_id
515: AND lid.entity_name = 'DEMAND_ID'
516: AND ms.demand_id = lid.local_id
517: AND ms.sr_instance_id = lid.instance_id;
923: DELETE_MSC_TABLE( 'MSC_RESERVATIONS', v_instance_id, -1);
924:
925: -----------------------DELETE Demand----------------------------
926: DELETE_MSC_TABLE( 'MSC_DEMANDS', v_instance_id, -1 );
927: DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', v_instance_id, NULL);
928:
929:
930: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',
931: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
1013: p_plan_id => -1,
1014: p_sub_str => ' and trunc(USING_ASSEMBLY_DEMAND_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1015:
1016:
1017: DELETE_MSC_TABLE( p_table_name =>'MSC_SALES_ORDERS',
1018: p_instance_id => v_instance_id,
1019: p_plan_id => NULL,
1020: p_sub_str => ' and trunc(REQUIREMENT_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1021:
1554: ---------------- DEMAND -------------
1555: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEMANDS', p_instance_id, NULL);
1556: COMMIT;
1557: ---------------- SALES ORDER -------------
1558: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', p_instance_id, NULL);
1559: COMMIT;
1560: ---------------- HARD RESERVATION -------------
1561: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RESERVATIONS', p_instance_id, NULL);
1562: COMMIT;