DBA Data[Home] [Help]

APPS.CTO_CONFIGURED_ITEM_GRP dependencies on BOM_CTO_ORDER_LINES_GT

Line 99: FROM bom_cto_order_lines_gt

95: SELECT line_id,
96: parent_ato_line_id,
97: ato_line_id,
98: perform_match
99: FROM bom_cto_order_lines_gt
100: WHERE bom_item_type = '1'
101: AND wip_supply_type <> 6;
102:
103: CURSOR c_debug IS

Line 123: FROM bom_cto_order_lines_gt;

119: perform_match,
120: config_creation,
121: option_specific,
122: oss_error_code
123: FROM bom_cto_order_lines_gt;
124:
125:
126:
127: BEGIN

Line 181: FROM bom_cto_order_lines_gt

177: lStmtNum:=40;
178: BEGIN
179: SELECT 'Y'
180: INTO l_model_exists
181: FROM bom_cto_order_lines_gt
182: WHERE line_id = ato_line_id
183: AND top_model_line_id is not null
184: AND rownum = 1;
185: EXCEPTION

Line 243: FROM bom_cto_order_lines_gt

239: lStmtNum:=80;
240: SELECT ato_line_id
241: BULK COLLECT INTO
242: l_ato_line_tbl
243: FROM bom_cto_order_lines_gt
244: WHERE line_id =ato_line_id
245: AND top_model_line_id is not null
246: AND config_item_id is null
247: AND bom_item_type = '1'; --implies item not re-used

Line 301: FROM bom_cto_order_lines_gt;

297: --additional rows may get created during
298: --for MATCH 0n cases. remove comment after UT
299: p_cto_match_rec.config_item_id,
300: p_cto_match_rec.perform_match
301: FROM bom_cto_order_lines_gt;
302:
303:
304: END IF; --if model eixsts
305: