APPS.CTO_GOP_INTERFACE_PK dependencies on BOM_CTO_ORDER_LINES_GT

Line 102: FROM bom_cto_order_lines_gt;

98: perform_match,
99: config_creation,
100: option_specific,
101: oss_error_code
102: FROM bom_cto_order_lines_gt;
103:
104:
105: BEGIN
106:

Line 113: DELETE FROM bom_cto_order_lines_gt;

109: x_return_status := FND_API.G_RET_STS_SUCCESS;
110:
111:
112: lStmtNum := 10;
113: DELETE FROM bom_cto_order_lines_gt;
114:
115: lStmtNum := 20;
116: l_match_profile := FND_PROFILE.Value('BOM:MATCH_CONFIG');
117:

Line 137: from bom_cto_order_lines_gt;

133: IF PG_DEBUG = 5 THEN
134: lStmtNum := 50;
135: select count(*)
136: into l_count
137: from bom_cto_order_lines_gt;
138:
139: oe_debug_pub.add('count before insert into bCOL =>'||l_count,1);
140:
141: END IF;

Line 164: INSERT INTO bom_cto_order_lines_gt

160: -- insert fo grp api needed an extend api
161: -- and un-ncessary insertion of null values
162: lStmtNum:=10;
163: FORALL i in 1..l_last_index
164: INSERT INTO bom_cto_order_lines_gt
165: (
166: ATO_LINE_ID,
167: COMPONENT_CODE,
168: COMPONENT_SEQUENCE_ID,

Line 222: FROM bom_cto_order_lines_gt

218: lStmtNum:=40;
219: BEGIN
220: SELECT 'Y'
221: INTO l_model_exists
222: FROM bom_cto_order_lines_gt
223: WHERE line_id = ato_line_id
224: AND top_model_line_id is not null
225: AND rownum = 1;
226: EXCEPTION

Line 256: UPDATE bom_cto_order_lines_gt child

252:
253: IF l_PDS_ODS = 4 THEN --PDS
254:
255: lStmtNum:=60;
256: UPDATE bom_cto_order_lines_gt child
257: SET qty_per_parent_model =
258: --used round to be consistent with can_configuration code
259: ( SELECT ROUND(child.ordered_quantity/parent.ordered_quantity,7)
260: FROM bom_cto_order_lines_gt parent

Line 260: FROM bom_cto_order_lines_gt parent

256: UPDATE bom_cto_order_lines_gt child
257: SET qty_per_parent_model =
258: --used round to be consistent with can_configuration code
259: ( SELECT ROUND(child.ordered_quantity/parent.ordered_quantity,7)
260: FROM bom_cto_order_lines_gt parent
261: WHERE child.parent_ato_line_id= parent.line_id
262: )
263: --to filter out ato item order lines
264: WHERE top_model_line_id is not null;

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

331: --SQL statement which accesses other tables.
332: --In such cases, the join order may not be optimal due to the lack
333: --of stats on the temp table, hence hints should be used to ensure the optimal join order.
334:
335: UPDATE /*+ INDEX (GT BOM_CTO_ORDER_LINES_GT_N5) */ bom_cto_order_lines_gt GT
336: SET GT.config_creation = ( SELECT nvl(MTL.config_orgs,1)--3555026
337: FROM mtl_system_items MTL
338: WHERE MTL.inventory_item_id = GT.inventory_item_id -- bugfix 3391383
339: AND MTL.organization_id = GT.validation_org--3555026

Line 395: FROM bom_cto_order_lines_gt

391: p_match_rec_of_tab.parent_ato_line_id,
392: p_match_rec_of_tab.gop_parent_ato_line_id,
393: p_match_rec_of_tab.bom_item_type,
394: p_match_rec_of_tab.wip_supply_type
395: FROM bom_cto_order_lines_gt
396: ORDER BY line_id; --Bugfix 6055375
397:
398:
399: IF PG_DEBUG <> 0 THEN

Line 463: DELETE FROM bom_cto_order_lines_gt;

459:
460: lStmtNum:=100;
461:
462: --need this when we make bcol_gt a session table
463: DELETE FROM bom_cto_order_lines_gt;
464:
465: oe_debug_pub.add(' END TIME STAMP : '||to_char(sysdate,'hh:mi:ss')||' ',5);
466:
467: EXCEPTION