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_BOM_PK dependencies on MTL_SYSTEM_ITEMS

Line 34: | mtl_system_items_tl is not getting updated with correct description .

Line 304: lplanner_code mtl_system_items_vl.planner_code%type;

300: l_anumvalue wf_engine.numtabtyp;
301: l_atxtvalue wf_engine.texttabtyp;
302: luser_key varchar2(100);
303: litem_key varchar2(100);
304: lplanner_code mtl_system_items_vl.planner_code%type;
305:
306: v_problem_model varchar2(1000) ;
307: v_problem_config varchar2(1000) ;
308: v_error_org varchar2(1000) ;

Line 568: mtl_system_items msi,

564: begin --Bugfix 2374246
565: select CAL.CALENDAR_DATE
566: into lEstRelDate
567: from bom_calendar_dates cal,
568: mtl_system_items msi,
569: bom_cto_order_lines bcol,
570: mtl_parameters mp
571: where msi.organization_id = pOrgId
572: and msi.inventory_item_id = pModelId

Line 816: mtl_system_items msi_child ,

812: bom_inventory_components ic1,
813: bom_cto_order_lines bcol1, --Option
814: bom_cto_order_lines bcol2, -- Parent-Model
815: bom_cto_order_lines bcol3, -- Parent-component
816: mtl_system_items msi_child ,
817: mtl_system_items msi_parent
818: -- begin bugfix 1653881
819: where ic1.bill_sequence_id = ( -- this we find the assembly to which
820: select common_bill_sequence_id -- d1.component_seq_id belongs and then find

Line 817: mtl_system_items msi_parent

813: bom_cto_order_lines bcol1, --Option
814: bom_cto_order_lines bcol2, -- Parent-Model
815: bom_cto_order_lines bcol3, -- Parent-component
816: mtl_system_items msi_child ,
817: mtl_system_items msi_parent
818: -- begin bugfix 1653881
819: where ic1.bill_sequence_id = ( -- this we find the assembly to which
820: select common_bill_sequence_id -- d1.component_seq_id belongs and then find
821: from bom_bill_of_materials bbm -- bill for it in Mfg org.We find equivalent

Line 884: from mtl_system_items_kfv

880:
881: oe_debug_pub.add( 'SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
882:
883: select concatenated_segments into v_model_item_name
884: from mtl_system_items_kfv
885: where inventory_item_id = pModelId
886: and rownum = 1 ;
887:
888:

Line 1086: mtl_system_items si1,

1082: cto_msutil_pub.bom_batch_id
1083: from
1084: bom_cto_order_lines bcol1, -- component
1085: bom_cto_order_lines bcol2, -- Model
1086: mtl_system_items si1,
1087: mtl_system_items si2,
1088: bom_bill_of_materials b,
1089: bom_inventory_components ic1
1090: where si1.organization_id = pOrgId

Line 1087: mtl_system_items si2,

1083: from
1084: bom_cto_order_lines bcol1, -- component
1085: bom_cto_order_lines bcol2, -- Model
1086: mtl_system_items si1,
1087: mtl_system_items si2,
1088: bom_bill_of_materials b,
1089: bom_inventory_components ic1
1090: where si1.organization_id = pOrgId
1091: and bcol1.inventory_item_id = si1.inventory_item_id

Line 1252: from mtl_system_items

1248: END IF;
1249: select segment1
1250: into
1251: l_model_name
1252: from mtl_system_items
1253: where inventory_item_id=pModelId
1254: and rownum=1;
1255:
1256: l_token2(1).token_name :='MODEL';

Line 1321: from mtl_system_items_kfv msi, bom_cto_order_lines bcol

1317: select substrb(msi.concatenated_segments,1,50),
1318: 'Not Available' ,
1319: -1
1320: into v_missed_item,v_missed_line_number,v_order_number
1321: from mtl_system_items_kfv msi, bom_cto_order_lines bcol
1322: where msi.organization_id = bcol.ship_from_org_id
1323: and msi.inventory_item_id = bcol.inventory_item_id
1324: and bcol.line_id = v_missed_line_id;
1325:

Line 1336: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh

1332: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1333: ||to_char(option_number)),
1334: oeh.order_number
1335: into v_missed_item,v_missed_line_number,v_order_number
1336: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1337: where msi.organization_id = oel.ship_from_org_id
1338: and msi.inventory_item_id = oel.inventory_item_id
1339: and oel.header_id = oeh.header_id
1340: and oel.line_id = v_missed_line_id;

Line 1355: from mtl_system_items_kfv

1351: END IF;
1352:
1353: select substrb(concatenated_segments,1,50)
1354: into v_model
1355: from mtl_system_items_kfv
1356: where organization_id = pOrgId
1357: and inventory_item_id = pModelId ;
1358:
1359: lStmtNum := 54;

Line 1482: select segment1 into v_problem_model from mtl_system_items

1478:
1479:
1480: /* DROPPED ITEM CAPTURE PROCESS */
1481:
1482: select segment1 into v_problem_model from mtl_system_items
1483: where inventory_item_id = pModelId and rownum = 1 ;
1484:
1485: select segment1 into v_problem_config from mtl_system_items
1486: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1485: select segment1 into v_problem_config from mtl_system_items

1481:
1482: select segment1 into v_problem_model from mtl_system_items
1483: where inventory_item_id = pModelId and rownum = 1 ;
1484:
1485: select segment1 into v_problem_config from mtl_system_items
1486: where inventory_item_id = pConfigId and rownum = 1 ;
1487:
1488: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1489: -- _deinitions with inv_organization_name_v

Line 1532: select segment1 into v_problem_model from mtl_system_items

1528:
1529:
1530: /* DROPPED ITEM CAPTURE PROCESS */
1531:
1532: select segment1 into v_problem_model from mtl_system_items
1533: where inventory_item_id = pModelId and rownum = 1 ;
1534:
1535: select segment1 into v_problem_config from mtl_system_items
1536: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1535: select segment1 into v_problem_config from mtl_system_items

1531:
1532: select segment1 into v_problem_model from mtl_system_items
1533: where inventory_item_id = pModelId and rownum = 1 ;
1534:
1535: select segment1 into v_problem_config from mtl_system_items
1536: where inventory_item_id = pConfigId and rownum = 1 ;
1537:
1538: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1539: -- _deinitions with inv_organization_name_v

Line 1608: select segment1 into v_problem_model from mtl_system_items

1604:
1605:
1606: /* DROPPED ITEM CAPTURE PROCESS */
1607:
1608: select segment1 into v_problem_model from mtl_system_items
1609: where inventory_item_id = pModelId and rownum = 1 ;
1610:
1611: select segment1 into v_problem_config from mtl_system_items
1612: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1611: select segment1 into v_problem_config from mtl_system_items

1607:
1608: select segment1 into v_problem_model from mtl_system_items
1609: where inventory_item_id = pModelId and rownum = 1 ;
1610:
1611: select segment1 into v_problem_config from mtl_system_items
1612: where inventory_item_id = pConfigId and rownum = 1 ;
1613:
1614: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1615: -- _deinitions with inv_organization_name_v

Line 1702: FROM mtl_system_items_vl item

1698: -- get the corresponding application user.
1699:
1700: SELECT u.user_name
1701: INTO lplanner_code
1702: FROM mtl_system_items_vl item
1703: ,mtl_planners p
1704: ,fnd_user u
1705: WHERE item.inventory_item_id = pModelId
1706: and item.organization_id = pOrgId

Line 1762: select segment1 into v_problem_model from mtl_system_items

1758:
1759:
1760: /* DROPPED ITEM CAPTURE PROCESS */
1761:
1762: select segment1 into v_problem_model from mtl_system_items
1763: where inventory_item_id = pModelId and rownum = 1 ;
1764:
1765: select segment1 into v_problem_config from mtl_system_items
1766: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1765: select segment1 into v_problem_config from mtl_system_items

1761:
1762: select segment1 into v_problem_model from mtl_system_items
1763: where inventory_item_id = pModelId and rownum = 1 ;
1764:
1765: select segment1 into v_problem_config from mtl_system_items
1766: where inventory_item_id = pConfigId and rownum = 1 ;
1767:
1768: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1769: -- _deinitions with inv_organization_name_v

Line 1843: FROM mtl_system_items_vl item

1839: -- get the corresponding application user.
1840:
1841: SELECT u.user_name
1842: INTO lplanner_code
1843: FROM mtl_system_items_vl item
1844: ,mtl_planners p
1845: ,fnd_user u
1846: WHERE item.inventory_item_id = pModelId
1847: and item.organization_id = pOrgId

Line 2521: from mtl_system_items

2517: END IF;
2518:
2519: select segment1 into
2520: l_model_name
2521: from mtl_system_items
2522: where inventory_item_id = pmodelid
2523: and organization_id = porgid;
2524:
2525:

Line 2528: from mtl_system_items

2524:
2525:
2526: select segment1 into
2527: l_comp_name
2528: from mtl_system_items
2529: where inventory_item_id = club_comp_rec.item_id
2530: and organization_id = porgid;
2531:
2532: select organization_name

Line 3177: from bom_inventory_comps_interface b , mtl_system_items msi

3173: b.parent_bill_seq_id, --isp bom
3174: b.plan_level, --isp bom
3175: b.model_comp_seq_id --isp bom
3176: , decode(b.basis_type,1,null,b.basis_type) /* LBM Change */
3177: from bom_inventory_comps_interface b , mtl_system_items msi
3178: where b.bill_sequence_id = pConfigBillId
3179: and b.component_item_id = msi.inventory_item_id
3180: and msi.organization_id = pOrgId ;
3181:

Line 3740: SELECT 'x' FROM MTL_SYSTEM_ITEMS

3736: -- FP Bug Fix 4761813
3737: -- Tuned the query to user not exists for perfomance reason
3738: and not exists
3739: (
3740: SELECT 'x' FROM MTL_SYSTEM_ITEMS
3741: WHERE ORGANIZATION_ID = pOrgId
3742: AND BC1.COMPONENT_ITEM_ID = INVENTORY_ITEM_ID
3743: AND BASE_ITEM_ID IS NOT NULL
3744: AND BOM_ITEM_TYPE = 4

Line 3759: the MTL_SYSTEM_ITEMS

3755: -- end bugfix 2765635
3756:
3757: /*---------------------------------------------------------------------+
3758: Update descriptions of the config items in
3759: the MTL_SYSTEM_ITEMS
3760: +----------------------------------------------------------------------*/
3761:
3762: lStmtNum := 350;
3763: xTableName := 'MTL_SYSTEM_ITMES';

Line 4039: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,

4035: xErrorMessage out NOCOPY VARCHAR2,
4036: xMessageName out NOCOPY VARCHAR2)
4037: return integer is
4038:
4039: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
4040: xLineId bom_cto_order_lines.line_id%TYPE,
4041: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
4042: xSchShpdt date,
4043: xEstReldt date ) IS

Line 4090: mtl_system_items si1,

4086: nvl(bic.disable_date,g_futuredate) dis_date -- 3222932
4087: , nvl(bic.basis_type,1) basis_type /* LBM project */
4088: from bom_cto_order_lines bcol1, -- COMPONENT
4089: bom_cto_order_lines bcol2, -- MODEL
4090: mtl_system_items si1,
4091: mtl_system_items si2,
4092: bom_bill_of_materials bbm,
4093: bom_inventory_components bic, -- Components
4094: bom_inventory_components bic1, -- Parent

Line 4091: mtl_system_items si2,

4087: , nvl(bic.basis_type,1) basis_type /* LBM project */
4088: from bom_cto_order_lines bcol1, -- COMPONENT
4089: bom_cto_order_lines bcol2, -- MODEL
4090: mtl_system_items si1,
4091: mtl_system_items si2,
4092: bom_bill_of_materials bbm,
4093: bom_inventory_components bic, -- Components
4094: bom_inventory_components bic1, -- Parent
4095: bom_explosion_temp bet

Line 4339: mtl_system_items msi_child,

4335: from bom_inventory_components ic1,
4336: bom_cto_order_lines bcol1, -- Option
4337: bom_cto_order_lines bcol2, -- Parent-Model
4338: bom_cto_order_lines bcol3 , -- Parent-component
4339: mtl_system_items msi_child,
4340: mtl_system_items msi_parent
4341: where ic1.bill_sequence_id = (
4342: select common_bill_sequence_id
4343: from bom_bill_of_materials bbm

Line 4340: mtl_system_items msi_parent

4336: bom_cto_order_lines bcol1, -- Option
4337: bom_cto_order_lines bcol2, -- Parent-Model
4338: bom_cto_order_lines bcol3 , -- Parent-component
4339: mtl_system_items msi_child,
4340: mtl_system_items msi_parent
4341: where ic1.bill_sequence_id = (
4342: select common_bill_sequence_id
4343: from bom_bill_of_materials bbm
4344: where organization_id = pOrgId

Line 4399: from mtl_system_items_kfv

4395: if( v_zero_qty_count > 0 ) then
4396: oe_debug_pub.add( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
4397:
4398: select concatenated_segments into v_model_item_name
4399: from mtl_system_items_kfv
4400: where inventory_item_id = pModelId
4401: and rownum = 1 ;
4402:
4403: l_token1(1).token_name := 'MODEL_NAME';

Line 5132: from mtl_system_items

5128:
5129: select segment1
5130: into
5131: l_model_name
5132: from mtl_system_items
5133: where inventory_item_id=pModelId
5134: and rownum=1;
5135:
5136: l_token2(1).token_name :='MODEL';

Line 5272: from mtl_system_items msi

5268:
5269: select (ceil(nvl(msi.fixed_lead_time,0)
5270: + nvl(msi.variable_lead_time,0) * pQty))
5271: into pLeadTime
5272: from mtl_system_items msi
5273: where inventory_item_id = pModelId
5274: and organization_id = pOrgId;
5275:
5276: IF PG_DEBUG <> 0 THEN

Line 5421: from mtl_system_items

5417: and application_id = 401;
5418:
5419: lStmtNum := 285;
5420: select item_catalog_group_id into group_id
5421: from mtl_system_items
5422: where inventory_item_id = item_id
5423: and organization_id = org_id;
5424:
5425: IF PG_DEBUG <> 0 THEN

Line 5456: update mtl_system_items

5452: end loop;
5453: close cc;
5454:
5455: if idx <> 0 then
5456: update mtl_system_items
5457: set description = cat_value
5458: where inventory_item_id = item_id;
5459: /*and organization_id = org_id; Bugfix 2163311 */
5460: /* start bugfix 1845141 */

Line 5461: update mtl_system_items_tl

5457: set description = cat_value
5458: where inventory_item_id = item_id;
5459: /*and organization_id = org_id; Bugfix 2163311 */
5460: /* start bugfix 1845141 */
5461: update mtl_system_items_tl
5462: set description = cat_value
5463: where inventory_item_id = item_id;
5464: /*and organization_id = org_id; Bugfix 2163311 */
5465: /* end bugfix 1845141 */

Line 5529: lplanner_code mtl_system_items_vl.planner_code%type;

5525: l_anumvalue wf_engine.numtabtyp;
5526: l_atxtvalue wf_engine.texttabtyp;
5527: luser_key varchar2(100);
5528: litem_key varchar2(100);
5529: lplanner_code mtl_system_items_vl.planner_code%type;
5530:
5531: porder_no number := 2222 ;
5532: pline_no number := 1111 ;
5533: