DBA Data[Home] [Help]

APPS.MST_PQ_WORKS dependencies on MST_ORDER_SELECTION_CRITERIA

Line 881: DELETE MST_ORDER_SELECTION_CRITERIA

877: ELSIF P_QUERY_TYPE = 2 THEN
878: DELETE MST_CM_SELECTION_CRITERIA
879: WHERE query_id = p_query_id;
880: ELSIF P_QUERY_TYPE = 3 THEN
881: DELETE MST_ORDER_SELECTION_CRITERIA
882: WHERE query_id = p_query_id;
883: ELSIF P_QUERY_TYPE = 4 THEN
884: DELETE MST_EXCEP_SELECTION_CRITERIA
885: WHERE query_id = p_query_id;

Line 2634: FROM mst_order_selection_criteria

2630: CUSTOMERS , CUSTOMER_IDS ,
2631: SUPPLIERS , SUPPLIER_IDS ,
2632: WEIGHT_TYPE , WEIGHT_FROM , WEIGHT_TO ,
2633: CUBE_TYPE , CUBE_FROM , CUBE_TO
2634: FROM mst_order_selection_criteria
2635: WHERE query_id = p_query_id;
2636:
2637: l_rec_orders cur_orders%ROWTYPE;
2638: