eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_CONFIG_ITEM_PK dependencies on BOM_CTO_ORDER_LINES

Line 410: from bom_cto_order_lines

406: end if;
407:
408: select parent_ato_line_id, ato_line_id
409: into l_line_id, l_ato_line_id
410: from bom_cto_order_lines
411: where line_id = l_line_id;
412:
413: exit when l_line_id = l_ato_line_id;
414: end loop;

Line 441: from bom_cto_order_lines

437: end if;
438:
439: select parent_ato_line_id, ato_line_id
440: into l_line_id, l_ato_line_id
441: from bom_cto_order_lines
442: where line_id = l_line_id;
443:
444: exit when l_line_id = l_ato_line_id;
445: end loop;

Line 1578: -- deleting from bom_cto_order_lines and bom_cto_src_orgs

1574:
1575:
1576:
1577: --
1578: -- deleting from bom_cto_order_lines and bom_cto_src_orgs
1579: -- for this top ato line id
1580: --
1581:
1582: lStmtNumber := 550;

Line 4234: v_program_id bom_cto_order_lines.program_id%type ;

4230: bug 2706981 was used to provide an alternate logic
4231: */
4232:
4233:
4234: v_program_id bom_cto_order_lines.program_id%type ;
4235: x_return_status varchar2(1);
4236:
4237: lOptionNum number ; -- 2652379 : new variable
4238: v_ato_line_id number ;

Line 4256: from bom_cto_order_lines where line_id = pLineId ;

4252: /* Added by Sushant for checking preconfigure bom module populated records */
4253: -- bugfix 2267646 Added nvl
4254:
4255: select NVL(program_id,0) , ato_line_id into v_program_id , v_ato_line_id
4256: from bom_cto_order_lines where line_id = pLineId ;
4257:
4258:
4259: /* BUG #1957336 Change for preconfigure bom by Sushant Sawant */
4260: /* Changes for patchset J

Line 5382: bom_cto_order_lines bcol

5378:
5379: from
5380: mtl_system_items_b m, -- Model
5381: bom_cto_src_orgs bcso,
5382: bom_cto_order_lines bcol
5383: where m.inventory_item_id = pModelId
5384: and bcso.model_item_id = pModelId
5385: and bcso.line_id = pLineId
5386: and bcol.line_id = bcso.line_id

Line 5515: bom_cto_order_lines l

5511:
5512: select i.weight_uom_code, i.volume_uom_code
5513: into o_weight_uom, o_volume_uom
5514: from mtl_system_items i,
5515: bom_cto_order_lines l
5516: where l.line_id = pLineId -- model line id
5517: and l.inventory_item_id = i.inventory_item_id
5518: and i.organization_id = lValidationOrg;
5519:

Line 5541: bom_cto_order_lines l

5537: from mtl_units_of_measure
5538: where uom_class = (select uom1.uom_class
5539: from mtl_units_of_measure uom1,
5540: mtl_system_items i,
5541: bom_cto_order_lines l
5542: where l.parent_ato_line_id = pLineId
5543: -- mbsk: replaced ato_line_id with parent_ato_line_id
5544: and l.item_type_code not in ('INCLUDED', 'CONFIG')
5545: and l.inventory_item_id = i.inventory_item_id

Line 5576: bom_cto_order_lines l

5572: from mtl_units_of_measure
5573: where uom_class = (select uom1.uom_class
5574: from mtl_units_of_measure uom1,
5575: mtl_system_items i,
5576: bom_cto_order_lines l
5577: where l.parent_ato_line_id = pLineId
5578: -- mbsk: replaced ato_line_id with parent_ato_line_id
5579: and l.item_type_code not in ('INCLUDED', 'CONFIG')
5580: and l.inventory_item_id = i.inventory_item_id

Line 5814: -- update bom_cto_order_lines with new config item

5810: END LOOP;
5811:
5812:
5813: --
5814: -- update bom_cto_order_lines with new config item
5815: --
5816:
5817: lStmtNumber := 120;
5818: lStatus := CTO_UTILITY_PK.Update_Order_Lines(

Line 5975: FROM bom_cto_order_lines l,

5971: Round( ( l.ordered_quantity / l_model.ordered_quantity), 7) , /* Support Decimal-Qty for Option Items */
5972: l.inventory_item_id) ) weight,
5973: msi.weight_uom_code uom,
5974: msi.inventory_item_id
5975: FROM bom_cto_order_lines l,
5976: bom_cto_order_lines l_model,
5977: mtl_system_items msi
5978: WHERE (l.parent_ato_line_id = x_a_line_id
5979: -- MLMO:replaced ato_line_id with parent_ato_line_id and added OR condn

Line 5976: bom_cto_order_lines l_model,

5972: l.inventory_item_id) ) weight,
5973: msi.weight_uom_code uom,
5974: msi.inventory_item_id
5975: FROM bom_cto_order_lines l,
5976: bom_cto_order_lines l_model,
5977: mtl_system_items msi
5978: WHERE (l.parent_ato_line_id = x_a_line_id
5979: -- MLMO:replaced ato_line_id with parent_ato_line_id and added OR condn
5980: or

Line 6010: FROM bom_cto_order_lines l,

6006: Round( ( l.ordered_quantity / l_model.ordered_quantity) , 7) , /* Support Decimal-Qty for Option Items */
6007: l.inventory_item_id) ) volume,
6008: msi.volume_uom_code uom,
6009: msi.inventory_item_id
6010: FROM bom_cto_order_lines l,
6011: bom_cto_order_lines l_model,
6012: mtl_system_items msi
6013: WHERE (l.parent_ato_line_id = x_a_line_id -- MLMO: replaced ato_line_id with parent_ato_line_id
6014: or

Line 6011: bom_cto_order_lines l_model,

6007: l.inventory_item_id) ) volume,
6008: msi.volume_uom_code uom,
6009: msi.inventory_item_id
6010: FROM bom_cto_order_lines l,
6011: bom_cto_order_lines l_model,
6012: mtl_system_items msi
6013: WHERE (l.parent_ato_line_id = x_a_line_id -- MLMO: replaced ato_line_id with parent_ato_line_id
6014: or
6015: l.line_id = x_a_line_id)

Line 6205: v_program_id bom_cto_order_lines.program_id%type ;

6201:
6202: -- x_item_rev_seq number; bugfix 3026929
6203:
6204: multiorg_error exception;
6205: v_program_id bom_cto_order_lines.program_id%type ;
6206:
6207: l_cto_cost_type_id number;
6208:
6209: lCnt number; --Bugfix 6717614

Line 6315: from bom_cto_order_lines

6311:
6312:
6313: /* added by Sushant to check preconfigure bom populated records */
6314: select nvl( program_id , 0 ) into v_program_id
6315: from bom_cto_order_lines
6316: where line_id = pLineId ;
6317:
6318:
6319: lStmtNumber := 200;

Line 7414: from bom_cto_order_lines bcol

7410: -- projects are assigned to different orgs.
7411: --
7412: select ship_from_org_id
7413: into lShipFromOrg
7414: from bom_cto_order_lines bcol
7415: where line_id = pLineID;
7416:
7417: l_cost_group_id := get_cost_group(lShipFromOrg, pLineID);
7418:

Line 10177: bom_cto_order_lines bcol,

10173: --end r12,4574899
10174: from
10175: mtl_system_items_b m, -- Model
10176: mtl_system_items_b config,
10177: bom_cto_order_lines bcol,
10178: bom_cto_src_orgs bcso
10179: where m.inventory_item_id = p_model_id
10180: and bcso.model_item_id = p_model_id
10181: and bcso.line_id = p_line_id