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
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
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
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
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: