APPS.MSC_PURGE_LID dependencies on MSC_DEMANDS

Line 470: FROM msc_local_id_demand lid, msc_demands ms

466: WHERE lid.entity_name ='DISPOSITION_ID_FCT'
467: AND lid.instance_id = p_instance_id
468: MINUS
469: SELECT distinct lid.rowid
470: FROM msc_local_id_demand lid, msc_demands ms
471: WHERE lid.instance_id = p_instance_id
472: AND lid.entity_name = 'DISPOSITION_ID_FCT'
473: AND ms.sales_order_line_id = lid.local_id
474: AND ms.plan_id = -1

Line 485: FROM msc_local_id_demand lid, msc_demands ms

481: WHERE lid.entity_name ='DISPOSITION_ID_MDS'
482: AND lid.instance_id = p_instance_id
483: MINUS
484: SELECT distinct lid.rowid
485: FROM msc_local_id_demand lid, msc_demands ms
486: WHERE lid.instance_id = p_instance_id
487: AND lid.entity_name = 'DISPOSITION_ID_MDS'
488: AND ms.disposition_id = lid.local_id
489: AND ms.origination_type = 8

Line 926: DELETE_MSC_TABLE( 'MSC_DEMANDS', v_instance_id, -1 );

922: -----------------------DELETE Hard Reservations-----------------------
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',

Line 1011: DELETE_MSC_TABLE( p_table_name =>'MSC_DEMANDS',

1007:
1008:
1009: IF p_demand_flag = SYS_YES THEN
1010:
1011: DELETE_MSC_TABLE( p_table_name =>'MSC_DEMANDS',
1012: p_instance_id => v_instance_id,
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:

Line 1555: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_DEMANDS', p_instance_id, NULL);

1551: COMMIT;
1552: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CATEGORY_SETS', p_instance_id, NULL);
1553: COMMIT;
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;