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 MTL_SYSTEM_ITEMS_B

Line 428: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type

424:
425: end get_atp_flag;
426:
427:
428: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type
429: , p_atp_components_flag in mtl_system_items_b.atp_components_flag%type )
430: return char
431: is
432: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;

Line 429: , p_atp_components_flag in mtl_system_items_b.atp_components_flag%type )

425: end get_atp_flag;
426:
427:
428: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type
429: , p_atp_components_flag in mtl_system_items_b.atp_components_flag%type )
430: return char
431: is
432: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;
433: begin

Line 432: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;

428: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type
429: , p_atp_components_flag in mtl_system_items_b.atp_components_flag%type )
430: return char
431: is
432: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;
433: begin
434:
435: /* Note: Although a lot of similarity exists for some combination of flag values
436: the results are bound to change based on new functionality/bug fix issues.

Line 2709: , p_item_type mtl_system_items.bom_item_type%type )

2705:
2706:
2707: function evaluate_order( p_atp_flag mtl_system_items.atp_flag%type
2708: , p_atp_comp mtl_system_items.atp_components_flag%type
2709: , p_item_type mtl_system_items.bom_item_type%type )
2710: return number
2711: is
2712: begin
2713: if( p_atp_comp in ( 'C' , 'Y' ) AND p_atp_flag in ( 'R' , 'C')) then

Line 4347: select mtl_system_items_B_S.nextval

4343:
4344: lStmtNumber := 50;
4345:
4346: if lNumberMethod = 1 then
4347: select mtl_system_items_B_S.nextval
4348: into lNextNum
4349: from dual;
4350:
4351: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)

Line 4358: select to_char(mtl_system_items_B_S.nextval)

4354: into new_item_num
4355: from dual;
4356:
4357: elsif lNumberMethod = 2 then
4358: select to_char(mtl_system_items_B_S.nextval)
4359: into new_item_num
4360: from dual;
4361:
4362: -- 2652379 : When numbering method is 3 , i.e Replace with order num, line num;

Line 4464: select to_char(mtl_system_items_B_S.nextval)

4460: then
4461: IF PG_DEBUG <> 0 THEN
4462: oe_debug_pub.add( 'Create_Item: '|| 'generating unique name' ,2 );
4463: END IF;
4464: select to_char(mtl_system_items_B_S.nextval)
4465: into lNextNum
4466: from dual;
4467: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4468: end if;

Line 4479: select to_char(mtl_system_items_B_S.nextval)

4475:
4476: IF PG_DEBUG <> 0 THEN
4477: oe_debug_pub.add('Create_Item: ' || 'generating unique name' ,2 );
4478: END IF;
4479: select to_char(mtl_system_items_B_S.nextval)
4480: into lNextNum
4481: from dual;
4482: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4483: exit;

Line 4493: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;

4489:
4490: oe_debug_pub.add('Create_Item: ' || 'new_item number is ' || seg(app_col_ind) ,2 );
4491: END IF;
4492:
4493: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;
4494:
4495: IF PG_DEBUG <> 0 THEN
4496: oe_debug_pub.add('Create_Item: ' || 'new pConfigId is '||to_char(pConfigId),2);
4497: END IF;

Line 4580: insert into mtl_system_items_b

4576:
4577: --appsperf bug# 4905845, sql id 16104136
4578: --decrease comments within sql to max extent to reduce shared memory
4579:
4580: insert into mtl_system_items_b
4581: (inventory_item_id,
4582: organization_id,
4583: last_update_date,
4584: last_updated_by,

Line 5242: mtl_system_items_b m, -- Model

5238: 3,
5239: 2
5240:
5241: from
5242: mtl_system_items_b m, -- Model
5243: bom_cto_src_orgs bcso,
5244: bom_cto_order_lines bcol
5245: where m.inventory_item_id = pModelId
5246: and bcso.model_item_id = pModelId

Line 5252: from mtl_system_items_b

5248: and bcol.line_id = bcso.line_id
5249: and m.organization_id = bcso.organization_id
5250: and NOT EXISTS
5251: (select NULL
5252: from mtl_system_items_b
5253: where inventory_item_id = pConfigId
5254: and organization_id = m.organization_id);
5255:
5256:

Line 5259: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_b',2);

5255:
5256:
5257:
5258: IF PG_DEBUG <> 0 THEN
5259: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_b',2);
5260:
5261: oe_debug_pub.add('Create_Item: ' || 'Inserted '||sql%rowcount||' rows in mtl_system_items_b',2);
5262: END IF;
5263: -- added as part of bugfix 1811007

Line 5261: oe_debug_pub.add('Create_Item: ' || 'Inserted '||sql%rowcount||' rows in mtl_system_items_b',2);

5257:
5258: IF PG_DEBUG <> 0 THEN
5259: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_b',2);
5260:
5261: oe_debug_pub.add('Create_Item: ' || 'Inserted '||sql%rowcount||' rows in mtl_system_items_b',2);
5262: END IF;
5263: -- added as part of bugfix 1811007
5264:
5265:

Line 5503: from mtl_system_items b

5499: nvl( b.weight_uom_code, o_weight_uom) , -- bug# 3358194
5500: o_weight,
5501: b.inventory_item_id)
5502: ,nvl(b.weight_uom_code, o_weight_uom) -- bug# 3358194
5503: from mtl_system_items b
5504: where b.inventory_item_id = a.base_item_id
5505: and b.organization_id = a.organization_id)
5506: where a.inventory_item_id = pConfigId
5507: and a.unit_weight is null; -- bugfix 5623437

Line 5519: from mtl_system_items b

5515: nvl(b.volume_uom_code, o_volume_uom), -- bug# 3358194
5516: o_volume,
5517: b.inventory_item_id)
5518: ,nvl(b.volume_uom_code, o_volume_uom) -- bug# 3358194
5519: from mtl_system_items b
5520: where b.inventory_item_id = a.base_item_id
5521: and b.organization_id = a.organization_id)
5522: where a.inventory_item_id = pConfigId
5523: and a.unit_volume is null; -- bugfix 5623437;

Line 5582: -- bugfix 2457514 mtl_system_items_b m, -- Model

5578: and t.organization_id = m.organization_id
5579: and t.language = m.language );
5580: */
5581: from
5582: -- bugfix 2457514 mtl_system_items_b m, -- Model
5583: mtl_system_items_tl m, -- 2457514
5584: bom_cto_src_orgs bcso,
5585: fnd_languages l
5586: where m.inventory_item_id = pModelId

Line 8193: from mtl_system_items_b_kfv

8189: END IF;
8190:
8191: Select concatenated_segments
8192: into l_model_tab(1).ordered_item
8193: from mtl_system_items_b_kfv
8194: where inventory_item_id = pConfigId
8195: and organization_id = pOrgId;
8196:
8197: lStmtNumber := 395;

Line 9171: insert into mtl_system_items_b

9167:
9168:
9169: oe_debug_pub.add( 'Entered Create Preconfigured Item ' , 1 ) ;
9170:
9171: insert into mtl_system_items_b
9172: (inventory_item_id,
9173: organization_id,
9174: last_update_date,
9175: last_updated_by,

Line 9832: mtl_system_items_b m, -- Model

9828: 3, --repair_program
9829: 2 --outsourced_assembly
9830: --end r12,4574899
9831: from
9832: mtl_system_items_b m, -- Model
9833: mtl_system_items_b config,
9834: bom_cto_order_lines bcol,
9835: bom_cto_src_orgs bcso
9836: where m.inventory_item_id = p_model_id

Line 9833: mtl_system_items_b config,

9829: 2 --outsourced_assembly
9830: --end r12,4574899
9831: from
9832: mtl_system_items_b m, -- Model
9833: mtl_system_items_b config,
9834: bom_cto_order_lines bcol,
9835: bom_cto_src_orgs bcso
9836: where m.inventory_item_id = p_model_id
9837: and bcso.model_item_id = p_model_id

Line 9845: from mtl_system_items_b

9841: and config.organization_id = bcol.ship_from_org_id
9842: and m.organization_id = bcso.organization_id
9843: and NOT EXISTS
9844: (select NULL
9845: from mtl_system_items_b
9846: where inventory_item_id = p_config_id
9847: and organization_id = bcso.organization_id);
9848:
9849: