DBA Data[Home] [Help]

APPS.CTO_MANUAL_LINK_CONFIG dependencies on OE_ORDER_LINES_ALL

Line 28: oe_order_lines_all

24:
25: /*****************************************************************************
26: Function: link_config
27: Parameters: p_model_line_id - line id of the top model in
28: oe_order_lines_all
29: p_config_item_id - config id of the selected configuration
30: item to which the model line will be linked.
31: x_error_message - error message if match function fails
32: x_message_name - name of error message if match

Line 139: from oe_order_lines_all oel

135:
136: l_stmt_num := 105;
137: select oel.inventory_item_id, oel.ship_from_org_id
138: into l_model_id, l_org_id
139: from oe_order_lines_all oel
140: where oel.line_id = p_model_line_id;
141:
142: /*------------------------------------------+
143: Link only if config line does not exist.

Line 289: from oe_order_lines_all

285:
286: l_stmt_num := 140;
287: select line_id, header_id
288: into l_config_line_id, l_header_id
289: from oe_order_lines_all
290: where ato_line_id = p_model_line_id
291: and item_type_code = 'CONFIG';
292:
293: IF PG_DEBUG <> 0 THEN

Line 591: from oe_order_lines_all oel, --model line

587:
588:
589: select distinct 1
590: into l_valid
591: from oe_order_lines_all oel, --model line
592: mtl_system_items msi --config item
593: where oel.line_id = p_model_line_id
594: and oel.inventory_item_id = msi.base_item_id
595: and msi.inventory_item_id = p_config_item_id;