APPS.CTO_GOP_INTERFACE_PK dependencies on BOM_CTO_ORDER_LINES_GT

Line 198: FROM bom_cto_order_lines_gt;

194: perform_match,
195: config_creation,
196: option_specific,
197: oss_error_code
198: FROM bom_cto_order_lines_gt;
199:
200:
201: BEGIN
202:

Line 209: DELETE FROM bom_cto_order_lines_gt;

205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207:
208: lStmtNum := 10;
209: DELETE FROM bom_cto_order_lines_gt;
210:
211: lStmtNum := 20;
212: l_match_profile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
213:

Line 233: from bom_cto_order_lines_gt;

229: IF PG_DEBUG = 5 THEN
230: lStmtNum := 50;
231: select count(*)
232: into l_count
233: from bom_cto_order_lines_gt;
234:
235: oe_debug_pub.add('count before insert into bCOL =>'||l_count,1);
236:
237: END IF;

Line 260: INSERT INTO bom_cto_order_lines_gt

256: -- insert fo grp api needed an extend api
257: -- and un-ncessary insertion of null values
258: lStmtNum:=10;
259: FORALL i in 1..l_last_index
260: INSERT INTO bom_cto_order_lines_gt
261: (
262: ATO_LINE_ID,
263: COMPONENT_CODE,
264: COMPONENT_SEQUENCE_ID,

Line 318: FROM bom_cto_order_lines_gt

314: lStmtNum:=40;
315: BEGIN
316: SELECT 'Y'
317: INTO l_model_exists
318: FROM bom_cto_order_lines_gt
319: WHERE line_id = ato_line_id
320: AND top_model_line_id is not null
321: AND rownum = 1;
322: EXCEPTION

Line 354: UPDATE bom_cto_order_lines_gt child

350:
351: lStmtNum:=60;
352: /* Bugfix 9452600: This sql returns "ORA-01476: divisor is equal to zero"
353: if some of the lines in a configuration are cancelled.
354: UPDATE bom_cto_order_lines_gt child
355: SET qty_per_parent_model =
356: --used round to be consistent with can_configuration code
357: ( SELECT ROUND(child.ordered_quantity/parent.ordered_quantity,7)
358: FROM bom_cto_order_lines_gt parent

Line 358: FROM bom_cto_order_lines_gt parent

354: UPDATE bom_cto_order_lines_gt child
355: SET qty_per_parent_model =
356: --used round to be consistent with can_configuration code
357: ( SELECT ROUND(child.ordered_quantity/parent.ordered_quantity,7)
358: FROM bom_cto_order_lines_gt parent
359: WHERE child.parent_ato_line_id= parent.line_id
360: )
361: --to filter out ato item order lines
362: WHERE top_model_line_id is not null;

Line 365: UPDATE bom_cto_order_lines_gt child

361: --to filter out ato item order lines
362: WHERE top_model_line_id is not null;
363: */
364:
365: UPDATE bom_cto_order_lines_gt child
366: SET qty_per_parent_model =
367: ( SELECT ROUND(DECODE(parent.ordered_quantity, 0 , 0, (child.ordered_quantity/parent.ordered_quantity)),7)
368: FROM bom_cto_order_lines_gt parent
369: WHERE child.parent_ato_line_id= parent.line_id

Line 368: FROM bom_cto_order_lines_gt parent

364:
365: UPDATE bom_cto_order_lines_gt child
366: SET qty_per_parent_model =
367: ( SELECT ROUND(DECODE(parent.ordered_quantity, 0 , 0, (child.ordered_quantity/parent.ordered_quantity)),7)
368: FROM bom_cto_order_lines_gt parent
369: WHERE child.parent_ato_line_id= parent.line_id
370: )
371: WHERE top_model_line_id IS NOT NULL;
372: --End bugfix 9452600

Line 451: UPDATE /*+ INDEX (GT BOM_CTO_ORDER_LINES_GT_N5) */ bom_cto_order_lines_gt GT

447: --SQL statement which accesses other tables.
448: --In such cases, the join order may not be optimal due to the lack
449: --of stats on the temp table, hence hints should be used to ensure the optimal join order.
450:
451: UPDATE /*+ INDEX (GT BOM_CTO_ORDER_LINES_GT_N5) */ bom_cto_order_lines_gt GT
452: SET GT.config_creation = ( SELECT nvl(MTL.config_orgs,1)--3555026
453: FROM mtl_system_items MTL
454: WHERE MTL.inventory_item_id = GT.inventory_item_id -- bugfix 3391383
455: AND MTL.organization_id = GT.validation_org--3555026

Line 512: FROM bom_cto_order_lines_gt

508: p_match_rec_of_tab.parent_ato_line_id,
509: p_match_rec_of_tab.gop_parent_ato_line_id,
510: p_match_rec_of_tab.bom_item_type,
511: p_match_rec_of_tab.wip_supply_type
512: FROM bom_cto_order_lines_gt
513: ORDER BY line_id; --Bugfix 6055375*/
514:
515: --Bugfix 8636348: The collection needs to be cleaned up before repopulating
516: IF PG_DEBUG <> 0 THEN

Line 568: FROM bom_cto_order_lines_gt

564: p_match_rec_of_tab.BOM_ITEM_TYPE,
565: p_match_rec_of_tab.WIP_SUPPLY_TYPE,
566: p_match_rec_of_tab.OSS_ERROR_CODE,
567: p_match_rec_of_tab.SHIP_FROM_ORG_ID
568: FROM bom_cto_order_lines_gt
569: ORDER BY line_id;
570: --End Bugfix 8636348
571:
572:

Line 635: DELETE FROM bom_cto_order_lines_gt;

631:
632: lStmtNum:=100;
633:
634: --need this when we make bcol_gt a session table
635: DELETE FROM bom_cto_order_lines_gt;
636:
637: --Bugfix 8636348: Adding this portion for debug purposes
638: IF PG_DEBUG <> 0 THEN
639: oe_debug_pub.add('CTOGOPIB: After deleting records from bcol_gt');