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 503: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type

499:
500: end get_atp_flag;
501:
502:
503: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type
504: , p_atp_components_flag in mtl_system_items_b.atp_components_flag%type )
505: return char
506: is
507: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;

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

500: end get_atp_flag;
501:
502:
503: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type
504: , p_atp_components_flag in mtl_system_items_b.atp_components_flag%type )
505: return char
506: is
507: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;
508: begin

Line 507: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;

503: function evaluate_atp_attributes( p_atp_flag in mtl_system_items_b.atp_flag%type
504: , p_atp_components_flag in mtl_system_items_b.atp_components_flag%type )
505: return char
506: is
507: v_atp_components_flag mtl_system_items_b.atp_components_flag%type ;
508: begin
509:
510: /* Note: Although a lot of similarity exists for some combination of flag values
511: the results are bound to change based on new functionality/bug fix issues.

Line 2802: , p_item_type mtl_system_items.bom_item_type%type )

2798:
2799:
2800: function evaluate_order( p_atp_flag mtl_system_items.atp_flag%type
2801: , p_atp_comp mtl_system_items.atp_components_flag%type
2802: , p_item_type mtl_system_items.bom_item_type%type )
2803: return number
2804: is
2805: begin
2806: if( p_atp_comp in ( 'C' , 'Y' ) AND p_atp_flag in ( 'R' , 'C')) then

Line 4442: select mtl_system_items_B_S.nextval

4438:
4439: lStmtNumber := 50;
4440:
4441: if lNumberMethod = 1 then
4442: select mtl_system_items_B_S.nextval
4443: into lNextNum
4444: from dual;
4445:
4446: -- bugfix 1933740 : Replaced seg(1) with seg(app_col_ind)

Line 4453: select to_char(mtl_system_items_B_S.nextval)

4449: into new_item_num
4450: from dual;
4451:
4452: elsif lNumberMethod = 2 then
4453: select to_char(mtl_system_items_B_S.nextval)
4454: into new_item_num
4455: from dual;
4456:
4457: -- 2652379 : When numbering method is 3 , i.e Replace with order num, line num;

Line 4559: select to_char(mtl_system_items_B_S.nextval)

4555: then
4556: IF PG_DEBUG <> 0 THEN
4557: oe_debug_pub.add( 'Create_Item: '|| 'generating unique name' ,2 );
4558: END IF;
4559: select to_char(mtl_system_items_B_S.nextval)
4560: into lNextNum
4561: from dual;
4562: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4563: end if;

Line 4574: select to_char(mtl_system_items_B_S.nextval)

4570:
4571: IF PG_DEBUG <> 0 THEN
4572: oe_debug_pub.add('Create_Item: ' || 'generating unique name' ,2 );
4573: END IF;
4574: select to_char(mtl_system_items_B_S.nextval)
4575: into lNextNum
4576: from dual;
4577: seg(app_col_ind) := new_item_num || lCiDel || lNextNum;
4578: exit;

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

4584:
4585: oe_debug_pub.add('Create_Item: ' || 'new_item number is ' || seg(app_col_ind) ,2 );
4586: END IF;
4587:
4588: select to_char(mtl_system_items_b_S.nextval) into pConfigId from dual;
4589:
4590: IF PG_DEBUG <> 0 THEN
4591: oe_debug_pub.add('Create_Item: ' || 'new pConfigId is '||to_char(pConfigId),2);
4592: END IF;

Line 4678: insert into mtl_system_items_b

4674:
4675: -- Bug 9223457.added additional attribute columns added in 12.1
4676: -- for mtl_sys_items.pdube
4677:
4678: insert into mtl_system_items_b
4679: (inventory_item_id,
4680: organization_id,
4681: last_update_date,
4682: last_updated_by,

Line 5380: mtl_system_items_b m, -- Model

5376: 3,
5377: 2
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

Line 5390: from mtl_system_items_b

5386: and bcol.line_id = bcso.line_id
5387: and m.organization_id = bcso.organization_id
5388: and NOT EXISTS
5389: (select NULL
5390: from mtl_system_items_b
5391: where inventory_item_id = pConfigId
5392: and organization_id = m.organization_id);
5393:
5394: sqlcnt := sql%rowcount; -- Added for bug 8305535

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

5393:
5394: sqlcnt := sql%rowcount; -- Added for bug 8305535
5395:
5396: IF PG_DEBUG <> 0 THEN
5397: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_b',2);
5398:
5399: oe_debug_pub.add('Create_Item: ' || 'Inserted '||sqlcnt||' rows in mtl_system_items_b',2);
5400: END IF;
5401: -- added as part of bugfix 1811007

Line 5399: oe_debug_pub.add('Create_Item: ' || 'Inserted '||sqlcnt||' rows in mtl_system_items_b',2);

5395:
5396: IF PG_DEBUG <> 0 THEN
5397: oe_debug_pub.add('Create_Item: ' || 'after insert:mtl_system_items_b',2);
5398:
5399: oe_debug_pub.add('Create_Item: ' || 'Inserted '||sqlcnt||' rows in mtl_system_items_b',2);
5400: END IF;
5401: -- added as part of bugfix 1811007
5402:
5403: --Start Bugfix 8305535

Line 5659: from mtl_system_items b

5655: nvl( b.weight_uom_code, o_weight_uom) , -- bug# 3358194
5656: o_weight,
5657: b.inventory_item_id)
5658: ,nvl(b.weight_uom_code, o_weight_uom) -- bug# 3358194
5659: from mtl_system_items b
5660: where b.inventory_item_id = a.base_item_id
5661: and b.organization_id = a.organization_id)
5662: where a.inventory_item_id = pConfigId
5663: and a.unit_weight is null; -- bugfix 5623437

Line 5675: from mtl_system_items b

5671: nvl(b.volume_uom_code, o_volume_uom), -- bug# 3358194
5672: o_volume,
5673: b.inventory_item_id)
5674: ,nvl(b.volume_uom_code, o_volume_uom) -- bug# 3358194
5675: from mtl_system_items b
5676: where b.inventory_item_id = a.base_item_id
5677: and b.organization_id = a.organization_id)
5678: where a.inventory_item_id = pConfigId
5679: and a.unit_volume is null; -- bugfix 5623437;

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

5735: and t.organization_id = m.organization_id
5736: and t.language = m.language );
5737: */
5738: from
5739: -- bugfix 2457514 mtl_system_items_b m, -- Model
5740: mtl_system_items_tl m, -- 2457514
5741: bom_cto_src_orgs bcso,
5742: fnd_languages l
5743: where

Line 8479: from mtl_system_items_b_kfv

8475: END IF;
8476:
8477: Select concatenated_segments
8478: into l_model_tab(1).ordered_item
8479: from mtl_system_items_b_kfv
8480: where inventory_item_id = pConfigId
8481: and organization_id = pOrgId;
8482:
8483: lStmtNumber := 395;

Line 9474: insert into mtl_system_items_b

9470:
9471:
9472: oe_debug_pub.add( 'Entered Create Preconfigured Item ' , 1 ) ;
9473:
9474: insert into mtl_system_items_b
9475: (inventory_item_id,
9476: organization_id,
9477: last_update_date,
9478: last_updated_by,

Line 10175: mtl_system_items_b m, -- Model

10171: 3, --repair_program
10172: 2 --outsourced_assembly
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

Line 10176: mtl_system_items_b config,

10172: 2 --outsourced_assembly
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

Line 10188: from mtl_system_items_b

10184: and config.organization_id = bcol.ship_from_org_id
10185: and m.organization_id = bcso.organization_id
10186: and NOT EXISTS
10187: (select NULL
10188: from mtl_system_items_b
10189: where inventory_item_id = p_config_id
10190: and organization_id = bcso.organization_id);
10191:
10192: