APPS.OE_CONFIG_PVT dependencies on OE_ORDER_LINES_ALL

Line 222: UPDATE OE_ORDER_LINES_ALL

218: AND config_rev_nbr = p_config_rev_nbr
219: AND inventory_item_id = l_model_line_rec.inventory_item_id;
220:
221: -- Bug 6073974 Update the Configuration id for model line
222: UPDATE OE_ORDER_LINES_ALL
223: SET CONFIGURATION_ID = l_model_line_rec.configuration_id
224: WHERE inventory_item_id = l_model_line_rec.inventory_item_id
225: AND LINE_ID = l_model_line_rec.line_id;
226:

Line 2639: FROM oe_order_lines_all

2635: -- cursor modified, ## 1820608
2636:
2637: CURSOR ATO_MODELS IS
2638: SELECT unique(ato_line_id)
2639: FROM oe_order_lines_all
2640: WHERE top_model_line_id = p_top_model_line_id
2641: AND ato_line_id is not null
2642: AND item_type_code = OE_GLOBALS.G_ITEM_CLASS
2643: AND open_flag = 'Y'; -- ato subconfigs

Line 2648: FROM oe_order_lines_all opt, oe_order_lines_all ato_model

2644:
2645: CURSOR ATO_OPTIONS(p_ato_line_id IN NUMBER)
2646: IS
2647: SELECT opt.line_id
2648: FROM oe_order_lines_all opt, oe_order_lines_all ato_model
2649: WHERE opt.top_model_line_id = p_top_model_line_id AND
2650: ato_model.top_model_line_id = p_top_model_line_id AND
2651: ato_model.line_id = p_ato_line_id AND
2652: opt.open_flag = 'Y' AND

Line 2797: UPDATE OE_ORDER_LINES_ALL OEOPT

2793: IF l_debug_level > 0 THEN
2794: oe_debug_pub.add('OLD ATO_LINE_ID / NOT SPLIT' , 1 ) ;
2795: END IF;
2796:
2797: UPDATE OE_ORDER_LINES_ALL OEOPT
2798: SET ATO_LINE_ID =
2799: ( SELECT OEATO.LINE_ID
2800: FROM OE_ORDER_LINES_ALL OEATO
2801: WHERE OEATO.TOP_MODEL_LINE_ID =

Line 2800: FROM OE_ORDER_LINES_ALL OEATO

2796:
2797: UPDATE OE_ORDER_LINES_ALL OEOPT
2798: SET ATO_LINE_ID =
2799: ( SELECT OEATO.LINE_ID
2800: FROM OE_ORDER_LINES_ALL OEATO
2801: WHERE OEATO.TOP_MODEL_LINE_ID =
2802: OEOPT.TOP_MODEL_LINE_ID
2803: AND ITEM_TYPE_CODE = 'CLASS'
2804: AND OEATO.COMPONENT_CODE =

Line 2819: FROM OE_ORDER_LINES_ALL OEMIN

2815: AND replenish_to_order_flag = 'Y'
2816: )
2817: AND OEATO.COMPONENT_CODE =
2818: ( SELECT MIN( OEMIN.COMPONENT_CODE )
2819: FROM OE_ORDER_LINES_ALL OEMIN
2820: WHERE OEMIN.TOP_MODEL_LINE_ID
2821: = OEOPT.TOP_MODEL_LINE_ID
2822: AND OEMIN.COMPONENT_CODE =
2823: SUBSTR( OEOPT.COMPONENT_CODE, 1,