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 566: mtl_system_items msi,

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

Line 814: mtl_system_items msi_child ,

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

Line 815: mtl_system_items msi_parent

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

Line 882: from mtl_system_items_kfv

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

Line 1061: mtl_system_items si1,

1057: cto_msutil_pub.bom_batch_id
1058: from
1059: bom_cto_order_lines bcol1, -- component
1060: bom_cto_order_lines bcol2, -- Model
1061: mtl_system_items si1,
1062: mtl_system_items si2,
1063: bom_bill_of_materials b,
1064: bom_inventory_components ic1
1065: where si1.organization_id = pOrgId

Line 1062: mtl_system_items si2,

1058: from
1059: bom_cto_order_lines bcol1, -- component
1060: bom_cto_order_lines bcol2, -- Model
1061: mtl_system_items si1,
1062: mtl_system_items si2,
1063: bom_bill_of_materials b,
1064: bom_inventory_components ic1
1065: where si1.organization_id = pOrgId
1066: and bcol1.inventory_item_id = si1.inventory_item_id

Line 1226: from mtl_system_items

1222: END IF;
1223: select segment1
1224: into
1225: l_model_name
1226: from mtl_system_items
1227: where inventory_item_id=pModelId
1228: and rownum=1;
1229:
1230: l_token2(1).token_name :='MODEL';

Line 1295: from mtl_system_items_kfv msi, bom_cto_order_lines bcol

1291: select substrb(msi.concatenated_segments,1,50),
1292: 'Not Available' ,
1293: -1
1294: into v_missed_item,v_missed_line_number,v_order_number
1295: from mtl_system_items_kfv msi, bom_cto_order_lines bcol
1296: where msi.organization_id = bcol.ship_from_org_id
1297: and msi.inventory_item_id = bcol.inventory_item_id
1298: and bcol.line_id = v_missed_line_id;
1299:

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

1306: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'
1307: ||to_char(option_number)),
1308: oeh.order_number
1309: into v_missed_item,v_missed_line_number,v_order_number
1310: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1311: where msi.organization_id = oel.ship_from_org_id
1312: and msi.inventory_item_id = oel.inventory_item_id
1313: and oel.header_id = oeh.header_id
1314: and oel.line_id = v_missed_line_id;

Line 1329: from mtl_system_items_kfv

1325: END IF;
1326:
1327: select substrb(concatenated_segments,1,50)
1328: into v_model
1329: from mtl_system_items_kfv
1330: where organization_id = pOrgId
1331: and inventory_item_id = pModelId ;
1332:
1333: lStmtNum := 54;

Line 1456: select segment1 into v_problem_model from mtl_system_items

1452:
1453:
1454: /* DROPPED ITEM CAPTURE PROCESS */
1455:
1456: select segment1 into v_problem_model from mtl_system_items
1457: where inventory_item_id = pModelId and rownum = 1 ;
1458:
1459: select segment1 into v_problem_config from mtl_system_items
1460: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1459: select segment1 into v_problem_config from mtl_system_items

1455:
1456: select segment1 into v_problem_model from mtl_system_items
1457: where inventory_item_id = pModelId and rownum = 1 ;
1458:
1459: select segment1 into v_problem_config from mtl_system_items
1460: where inventory_item_id = pConfigId and rownum = 1 ;
1461:
1462: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1463: -- _deinitions with inv_organization_name_v

Line 1506: select segment1 into v_problem_model from mtl_system_items

1502:
1503:
1504: /* DROPPED ITEM CAPTURE PROCESS */
1505:
1506: select segment1 into v_problem_model from mtl_system_items
1507: where inventory_item_id = pModelId and rownum = 1 ;
1508:
1509: select segment1 into v_problem_config from mtl_system_items
1510: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1509: select segment1 into v_problem_config from mtl_system_items

1505:
1506: select segment1 into v_problem_model from mtl_system_items
1507: where inventory_item_id = pModelId and rownum = 1 ;
1508:
1509: select segment1 into v_problem_config from mtl_system_items
1510: where inventory_item_id = pConfigId and rownum = 1 ;
1511:
1512: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1513: -- _deinitions with inv_organization_name_v

Line 1582: select segment1 into v_problem_model from mtl_system_items

1578:
1579:
1580: /* DROPPED ITEM CAPTURE PROCESS */
1581:
1582: select segment1 into v_problem_model from mtl_system_items
1583: where inventory_item_id = pModelId and rownum = 1 ;
1584:
1585: select segment1 into v_problem_config from mtl_system_items
1586: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1585: select segment1 into v_problem_config from mtl_system_items

1581:
1582: select segment1 into v_problem_model from mtl_system_items
1583: where inventory_item_id = pModelId and rownum = 1 ;
1584:
1585: select segment1 into v_problem_config from mtl_system_items
1586: where inventory_item_id = pConfigId and rownum = 1 ;
1587:
1588: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1589: -- _deinitions with inv_organization_name_v

Line 1676: FROM mtl_system_items_vl item

1672: -- get the corresponding application user.
1673:
1674: SELECT u.user_name
1675: INTO lplanner_code
1676: FROM mtl_system_items_vl item
1677: ,mtl_planners p
1678: ,fnd_user u
1679: WHERE item.inventory_item_id = pModelId
1680: and item.organization_id = pOrgId

Line 1736: select segment1 into v_problem_model from mtl_system_items

1732:
1733:
1734: /* DROPPED ITEM CAPTURE PROCESS */
1735:
1736: select segment1 into v_problem_model from mtl_system_items
1737: where inventory_item_id = pModelId and rownum = 1 ;
1738:
1739: select segment1 into v_problem_config from mtl_system_items
1740: where inventory_item_id = pConfigId and rownum = 1 ;

Line 1739: select segment1 into v_problem_config from mtl_system_items

1735:
1736: select segment1 into v_problem_model from mtl_system_items
1737: where inventory_item_id = pModelId and rownum = 1 ;
1738:
1739: select segment1 into v_problem_config from mtl_system_items
1740: where inventory_item_id = pConfigId and rownum = 1 ;
1741:
1742: -- rkaza. bug 3742393. 08/11/2004. Replaced org_organization
1743: -- _deinitions with inv_organization_name_v

Line 1817: FROM mtl_system_items_vl item

1813: -- get the corresponding application user.
1814:
1815: SELECT u.user_name
1816: INTO lplanner_code
1817: FROM mtl_system_items_vl item
1818: ,mtl_planners p
1819: ,fnd_user u
1820: WHERE item.inventory_item_id = pModelId
1821: and item.organization_id = pOrgId

Line 2461: from mtl_system_items

2457: END IF;
2458:
2459: select segment1 into
2460: l_model_name
2461: from mtl_system_items
2462: where inventory_item_id = pmodelid
2463: and organization_id = porgid;
2464:
2465:

Line 2468: from mtl_system_items

2464:
2465:
2466: select segment1 into
2467: l_comp_name
2468: from mtl_system_items
2469: where inventory_item_id = club_comp_rec.item_id
2470: and organization_id = porgid;
2471:
2472: select organization_name

Line 3101: from bom_inventory_comps_interface b , mtl_system_items msi

3097: b.parent_bill_seq_id, --isp bom
3098: b.plan_level, --isp bom
3099: b.model_comp_seq_id --isp bom
3100: , decode(b.basis_type,1,null,b.basis_type) /* LBM Change */
3101: from bom_inventory_comps_interface b , mtl_system_items msi
3102: where b.bill_sequence_id = pConfigBillId
3103: and b.component_item_id = msi.inventory_item_id
3104: and msi.organization_id = pOrgId ;
3105:

Line 3640: SELECT 'x' FROM MTL_SYSTEM_ITEMS

3636: -- FP Bug Fix 4761813
3637: -- Tuned the query to user not exists for perfomance reason
3638: and not exists
3639: (
3640: SELECT 'x' FROM MTL_SYSTEM_ITEMS
3641: WHERE ORGANIZATION_ID = pOrgId
3642: AND BC1.COMPONENT_ITEM_ID = INVENTORY_ITEM_ID
3643: AND BASE_ITEM_ID IS NOT NULL
3644: AND BOM_ITEM_TYPE = 4

Line 3659: the MTL_SYSTEM_ITEMS

3655: -- end bugfix 2765635
3656:
3657: /*---------------------------------------------------------------------+
3658: Update descriptions of the config items in
3659: the MTL_SYSTEM_ITEMS
3660: +----------------------------------------------------------------------*/
3661:
3662: lStmtNum := 350;
3663: xTableName := 'MTL_SYSTEM_ITMES';

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

3856: xErrorMessage out NOCOPY VARCHAR2,
3857: xMessageName out NOCOPY VARCHAR2)
3858: return integer is
3859:
3860: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
3861: xLineId bom_cto_order_lines.line_id%TYPE,
3862: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
3863: xSchShpdt date,
3864: xEstReldt date ) IS

Line 3911: mtl_system_items si1,

3907: nvl(bic.disable_date,g_futuredate) dis_date -- 3222932
3908: , nvl(bic.basis_type,1) basis_type /* LBM project */
3909: from bom_cto_order_lines bcol1, -- COMPONENT
3910: bom_cto_order_lines bcol2, -- MODEL
3911: mtl_system_items si1,
3912: mtl_system_items si2,
3913: bom_bill_of_materials bbm,
3914: bom_inventory_components bic, -- Components
3915: bom_inventory_components bic1, -- Parent

Line 3912: mtl_system_items si2,

3908: , nvl(bic.basis_type,1) basis_type /* LBM project */
3909: from bom_cto_order_lines bcol1, -- COMPONENT
3910: bom_cto_order_lines bcol2, -- MODEL
3911: mtl_system_items si1,
3912: mtl_system_items si2,
3913: bom_bill_of_materials bbm,
3914: bom_inventory_components bic, -- Components
3915: bom_inventory_components bic1, -- Parent
3916: bom_explosion_temp bet

Line 4156: mtl_system_items msi_child,

4152: from bom_inventory_components ic1,
4153: bom_cto_order_lines bcol1, -- Option
4154: bom_cto_order_lines bcol2, -- Parent-Model
4155: bom_cto_order_lines bcol3 , -- Parent-component
4156: mtl_system_items msi_child,
4157: mtl_system_items msi_parent
4158: where ic1.bill_sequence_id = (
4159: select common_bill_sequence_id
4160: from bom_bill_of_materials bbm

Line 4157: mtl_system_items msi_parent

4153: bom_cto_order_lines bcol1, -- Option
4154: bom_cto_order_lines bcol2, -- Parent-Model
4155: bom_cto_order_lines bcol3 , -- Parent-component
4156: mtl_system_items msi_child,
4157: mtl_system_items msi_parent
4158: where ic1.bill_sequence_id = (
4159: select common_bill_sequence_id
4160: from bom_bill_of_materials bbm
4161: where organization_id = pOrgId

Line 4225: from mtl_system_items_kfv

4221: oe_debug_pub.add( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
4222:
4223:
4224: select concatenated_segments into v_model_item_name
4225: from mtl_system_items_kfv
4226: where inventory_item_id = pModelId
4227: and rownum = 1 ;
4228:
4229:

Line 4804: from mtl_system_items

4800:
4801: select segment1
4802: into
4803: l_model_name
4804: from mtl_system_items
4805: where inventory_item_id=pModelId
4806: and rownum=1;
4807:
4808: l_token2(1).token_name :='MODEL';

Line 4960: from mtl_system_items msi

4956:
4957: select (ceil(nvl(msi.fixed_lead_time,0)
4958: + nvl(msi.variable_lead_time,0) * pQty))
4959: into pLeadTime
4960: from mtl_system_items msi
4961: where inventory_item_id = pModelId
4962: and organization_id = pOrgId;
4963:
4964: IF PG_DEBUG <> 0 THEN

Line 5109: from mtl_system_items

5105: and application_id = 401;
5106:
5107: lStmtNum := 285;
5108: select item_catalog_group_id into group_id
5109: from mtl_system_items
5110: where inventory_item_id = item_id
5111: and organization_id = org_id;
5112:
5113: IF PG_DEBUG <> 0 THEN

Line 5144: update mtl_system_items

5140: end loop;
5141: close cc;
5142:
5143: if idx <> 0 then
5144: update mtl_system_items
5145: set description = cat_value
5146: where inventory_item_id = item_id;
5147: /*and organization_id = org_id; Bugfix 2163311 */
5148: /* start bugfix 1845141 */

Line 5149: update mtl_system_items_tl

5145: set description = cat_value
5146: where inventory_item_id = item_id;
5147: /*and organization_id = org_id; Bugfix 2163311 */
5148: /* start bugfix 1845141 */
5149: update mtl_system_items_tl
5150: set description = cat_value
5151: where inventory_item_id = item_id;
5152: /*and organization_id = org_id; Bugfix 2163311 */
5153: /* end bugfix 1845141 */

Line 5217: lplanner_code mtl_system_items_vl.planner_code%type;

5213: l_anumvalue wf_engine.numtabtyp;
5214: l_atxtvalue wf_engine.texttabtyp;
5215: luser_key varchar2(100);
5216: litem_key varchar2(100);
5217: lplanner_code mtl_system_items_vl.planner_code%type;
5218:
5219: porder_no number := 2222 ;
5220: pline_no number := 1111 ;
5221: