DBA Data[Home] [Help]

APPS.CTO_CONFIGURED_ITEM_GRP dependencies on BOM_CTO_ORDER_LINES_GT

Line 138: FROM bom_cto_order_lines_gt

134: SELECT line_id,
135: parent_ato_line_id,
136: ato_line_id,
137: perform_match
138: FROM bom_cto_order_lines_gt
139: WHERE bom_item_type = '1'
140: AND wip_supply_type <> 6;
141:
142: CURSOR c_debug IS

Line 162: FROM bom_cto_order_lines_gt;

158: perform_match,
159: config_creation,
160: option_specific,
161: oss_error_code
162: FROM bom_cto_order_lines_gt;
163:
164: BEGIN
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:

Line 214: FROM bom_cto_order_lines_gt

210: lStmtNum:=40;
211: BEGIN
212: SELECT 'Y'
213: INTO l_model_exists
214: FROM bom_cto_order_lines_gt
215: WHERE line_id = ato_line_id
216: AND top_model_line_id is not null
217: AND rownum = 1;
218: EXCEPTION

Line 274: FROM bom_cto_order_lines_gt

270: lStmtNum:=80;
271: SELECT ato_line_id
272: BULK COLLECT INTO
273: l_ato_line_tbl
274: FROM bom_cto_order_lines_gt
275: WHERE line_id =ato_line_id
276: AND top_model_line_id is not null
277: AND config_item_id is null
278: AND bom_item_type = '1'; --implies item not re-used

Line 332: FROM bom_cto_order_lines_gt

328: --additional rows may get created during
329: --for MATCH 0n cases. remove comment after UT
330: p_cto_match_rec.config_item_id,
331: p_cto_match_rec.perform_match
332: FROM bom_cto_order_lines_gt
333: order by line_id; --Bugfix 6055375
334:
335: END IF; --if model eixsts
336: