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 2934: FROM oe_order_lines_all

2930: -- cursor modified, ## 1820608
2931:
2932: CURSOR ATO_MODELS IS
2933: SELECT unique(ato_line_id)
2934: FROM oe_order_lines_all
2935: WHERE top_model_line_id = p_top_model_line_id
2936: AND ato_line_id is not null
2937: AND item_type_code = OE_GLOBALS.G_ITEM_CLASS
2938: AND open_flag = 'Y'; -- ato subconfigs

Line 2943: FROM oe_order_lines_all opt, oe_order_lines_all ato_model

2939:
2940: CURSOR ATO_OPTIONS(p_ato_line_id IN NUMBER)
2941: IS
2942: SELECT opt.line_id
2943: FROM oe_order_lines_all opt, oe_order_lines_all ato_model
2944: WHERE opt.top_model_line_id = p_top_model_line_id AND
2945: ato_model.top_model_line_id = p_top_model_line_id AND
2946: ato_model.line_id = p_ato_line_id AND
2947: opt.open_flag = 'Y' AND

Line 3224: UPDATE OE_ORDER_LINES_ALL OEOPT

3220: IF l_debug_level > 0 THEN
3221: oe_debug_pub.add('OLD ATO_LINE_ID / NOT SPLIT' , 1 ) ;
3222: END IF;
3223:
3224: UPDATE OE_ORDER_LINES_ALL OEOPT
3225: SET ATO_LINE_ID =
3226: ( SELECT OEATO.LINE_ID
3227: FROM OE_ORDER_LINES_ALL OEATO
3228: WHERE OEATO.TOP_MODEL_LINE_ID =

Line 3227: FROM OE_ORDER_LINES_ALL OEATO

3223:
3224: UPDATE OE_ORDER_LINES_ALL OEOPT
3225: SET ATO_LINE_ID =
3226: ( SELECT OEATO.LINE_ID
3227: FROM OE_ORDER_LINES_ALL OEATO
3228: WHERE OEATO.TOP_MODEL_LINE_ID =
3229: OEOPT.TOP_MODEL_LINE_ID
3230: AND ITEM_TYPE_CODE = 'CLASS'
3231: AND OEATO.COMPONENT_CODE =

Line 3246: FROM OE_ORDER_LINES_ALL OEMIN

3242: AND replenish_to_order_flag = 'Y'
3243: )
3244: AND OEATO.COMPONENT_CODE =
3245: ( SELECT MIN( OEMIN.COMPONENT_CODE )
3246: FROM OE_ORDER_LINES_ALL OEMIN
3247: WHERE OEMIN.TOP_MODEL_LINE_ID
3248: = OEOPT.TOP_MODEL_LINE_ID
3249: AND OEMIN.COMPONENT_CODE =
3250: SUBSTR( OEOPT.COMPONENT_CODE, 1,