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

Line 1151: mtl_system_items msi,

1147: BEGIN
1148: select CAL.CALENDAR_DATE
1149: into lEstRelDate
1150: from bom_calendar_dates cal,
1151: mtl_system_items msi,
1152: bom_cto_order_lines_upg bcolu,
1153: mtl_parameters mp
1154: where msi.organization_id = pOrgId
1155: and msi.inventory_item_id = pModelId

Line 1369: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881

1365: bom_inventory_components ic1,
1366: bom_cto_order_lines_upg bcol1, -- Option
1367: bom_cto_order_lines_upg bcol2, -- Parent-Model
1368: bom_cto_order_lines_upg bcol3, -- Parent-component
1369: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1370: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1371: where ic1.bill_sequence_id = (
1372: select common_bill_sequence_id
1373: from bom_bill_of_materials bbm

Line 1370: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881

1366: bom_cto_order_lines_upg bcol1, -- Option
1367: bom_cto_order_lines_upg bcol2, -- Parent-Model
1368: bom_cto_order_lines_upg bcol3, -- Parent-component
1369: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1370: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1371: where ic1.bill_sequence_id = (
1372: select common_bill_sequence_id
1373: from bom_bill_of_materials bbm
1374: where organization_id = pOrgId

Line 1427: from mtl_system_items_kfv

1423:
1424: WriteToLog( 'SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
1425:
1426: select concatenated_segments into v_model_item_name
1427: from mtl_system_items_kfv
1428: where inventory_item_id = pModelId
1429: and rownum = 1 ;
1430:
1431:

Line 1610: mtl_system_items si1,

1606: cto_msutil_pub.bom_batch_id
1607: from
1608: bom_cto_order_lines_upg bcol1, -- component
1609: bom_cto_order_lines_upg bcol2, -- Model
1610: mtl_system_items si1,
1611: mtl_system_items si2,
1612: bom_bill_of_materials b,
1613: bom_inventory_components ic1
1614: where si1.organization_id = pOrgId

Line 1611: mtl_system_items si2,

1607: from
1608: bom_cto_order_lines_upg bcol1, -- component
1609: bom_cto_order_lines_upg bcol2, -- Model
1610: mtl_system_items si1,
1611: mtl_system_items si2,
1612: bom_bill_of_materials b,
1613: bom_inventory_components ic1
1614: where si1.organization_id = pOrgId
1615: and bcol1.inventory_item_id = si1.inventory_item_id

Line 1765: from mtl_system_items_kfv

1761: BEGIN
1762:
1763: select substrb(concatenated_segments,1,50)
1764: into v_config
1765: from mtl_system_items_kfv
1766: where organization_id = pOrgId
1767: and inventory_item_id = pConfigId ;
1768: WriteToLog('Config name is.. '|| v_config ,5);
1769:

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

1790: select substrb(msi.concatenated_segments,1,50),
1791: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(option_number)),
1792: oeh.order_number
1793: into v_missed_item,v_missed_line_number,v_order_number
1794: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1795: where msi.organization_id = oel.ship_from_org_id
1796: and msi.inventory_item_id = oel.inventory_item_id
1797: and oel.header_id = oeh.header_id
1798: and oel.line_id = v_missed_line_id;

Line 1812: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1808: select substrb(msi.concatenated_segments,1,50),
1809: 'Not Available' ,
1810: -1
1811: into v_missed_item,v_missed_line_number,v_order_number
1812: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1813: where msi.organization_id = bcolu.ship_from_org_id
1814: and msi.inventory_item_id = bcolu.inventory_item_id
1815: and bcolu.line_id = v_missed_line_id;
1816:

Line 1834: from mtl_system_items_kfv

1830: lStmtNum := 53;
1831: WriteToLog('Select model.. ' ,5);
1832: select substrb(concatenated_segments,1,50)
1833: into v_model
1834: from mtl_system_items_kfv
1835: where organization_id = pOrgId
1836: and inventory_item_id = pModelId ;
1837:
1838: lStmtNum := 54;

Line 2464: mtl_system_items si1,

2460: os1.routing_sequence_id,
2461: l_batch_id
2462: from
2463: bom_cto_order_lines_upg bcol1,
2464: mtl_system_items si1,
2465: bom_operational_routings or1,
2466: bom_operation_sequences os1
2467: where bcol1.line_id = pLineId
2468: and bcol1.inventory_item_id = pModelId

Line 2498: mtl_system_items msi,

2494: l_batch_id
2495: from
2496: bom_cto_order_lines_upg bcol1, -- components
2497: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2498: mtl_system_items msi,
2499: bom_inventory_components ic1,
2500: bom_bill_of_materials b1,
2501: bom_operational_routings or1,
2502: bom_operation_sequences os1

Line 2563: mtl_system_items si2,

2559: l_batch_id
2560: from
2561: bom_operation_sequences os1,
2562: bom_operational_routings or1,
2563: mtl_system_items si2,
2564: bom_inventory_components ic1,
2565: bom_bill_of_materials b1,
2566: mtl_system_items si1
2567: where si1.organization_id = pOrgId

Line 2566: mtl_system_items si1

2562: bom_operational_routings or1,
2563: mtl_system_items si2,
2564: bom_inventory_components ic1,
2565: bom_bill_of_materials b1,
2566: mtl_system_items si1
2567: where si1.organization_id = pOrgId
2568: and si1.inventory_item_id = pModelId
2569: and si1.bom_item_type = 1 /* model */
2570: and b1.organization_id = si1.organization_id

Line 2887: mtl_system_items si1,

2883: os1.operation_seq_num,
2884: nvl(os1.operation_type,1),
2885: os1.routing_sequence_id
2886: from
2887: mtl_system_items si1,
2888: bom_cto_order_lines_upg bcol,
2889: bom_operational_routings or1,
2890: bom_operation_sequences os1
2891: where bcol.parent_ato_line_id = pLineId

Line 2980: mtl_system_items si2,

2976: os1.routing_sequence_id
2977: from
2978: bom_operation_sequences os1,
2979: bom_operational_routings or1,
2980: mtl_system_items si2,
2981: bom_inventory_components ic1,
2982: bom_bill_of_materials b1,
2983: mtl_system_items si1,
2984: bom_cto_order_lines_upg bcol /* Model or option class */

Line 2983: mtl_system_items si1,

2979: bom_operational_routings or1,
2980: mtl_system_items si2,
2981: bom_inventory_components ic1,
2982: bom_bill_of_materials b1,
2983: mtl_system_items si1,
2984: bom_cto_order_lines_upg bcol /* Model or option class */
2985: where bcol.parent_ato_line_id = pLineId
2986: and bcol.component_sequence_id is not null
2987: and bcol.ordered_quantity <> 0

Line 3443: from mtl_System_items

3439: else
3440: lstmtNum := 411;
3441: Select serial_number_control_code
3442: into l_ser_code
3443: from mtl_System_items
3444: where inventory_item_id = pModelId
3445: and organization_id =pOrgId;
3446:
3447: WriteToLog('serial_number_control_code of model is '||l_ser_code , 4);

Line 3878: from mtl_system_items

3874: WriteToLog( 'will not populated message CTO_CLUB_COMP_ERROR');
3875: END IF;
3876: select segment1 into
3877: l_model_name
3878: from mtl_system_items
3879: where inventory_item_id = pmodelid
3880: and organization_id = porgid;
3881:
3882:

Line 3885: from mtl_system_items

3881:
3882:
3883: select segment1 into
3884: l_comp_name
3885: from mtl_system_items
3886: where inventory_item_id = club_comp_rec.item_id
3887: and organization_id = porgid;
3888:
3889: select organization_name

Line 4484: mtl_system_items msi

4480: b.plan_level, --isp bom
4481: b.model_comp_seq_id --isp bom
4482: , decode(b.basis_type,1,null,b.basis_type) /* LBM change */
4483: from bom_inventory_comps_interface b,
4484: mtl_system_items msi
4485: where b.bill_sequence_id = lConfigBillId
4486: and b.component_item_id = msi.inventory_item_id
4487: and msi.organization_id = pOrgId;
4488:

Line 5010: SELECT 'x' FROM MTL_SYSTEM_ITEMS

5006: -- user exists clause instead of using not in for performance
5007: -- reason
5008: and not exists
5009: (
5010: SELECT 'x' FROM MTL_SYSTEM_ITEMS
5011: WHERE ORGANIZATION_ID = pOrgId
5012: AND BC1.COMPONENT_ITEM_ID = INVENTORY_ITEM_ID
5013: AND BASE_ITEM_ID IS NOT NULL
5014: AND BOM_ITEM_TYPE = 4

Line 5026: the MTL_SYSTEM_ITEMS

5022:
5023:
5024: /*---------------------------------------------------------------------+
5025: Update descriptions of the config items in
5026: the MTL_SYSTEM_ITEMS
5027: +----------------------------------------------------------------------*/
5028:
5029: lStmtNum := 350;
5030: xTableName := 'MTL_SYSTEM_ITMES';

Line 5538: mtl_system_items msi

5534: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
5535: AND bos1.routing_sequence_id = ( /* find the model routing */
5536: select routing_sequence_id
5537: from bom_operational_routings bor,
5538: mtl_system_items msi
5539: where brif.assembly_item_id = msi.inventory_item_id
5540: and brif.organization_id = msi.organization_id
5541: and bor.assembly_item_id = msi.base_item_id
5542: and bor.organization_id = msi.organization_id

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

5661: xErrorMessage out NOCOPY VARCHAR2,
5662: xMessageName out NOCOPY VARCHAR2)
5663: RETURN INTEGER IS
5664:
5665: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
5666: xLineId bom_cto_order_lines_upg.line_id%TYPE,
5667: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
5668: xSchShpdt date,
5669: xEstReldt date ) IS

Line 5716: mtl_system_items si1,

5712: nvl(bic.disable_date,g_futuredate) dis_date, -- 3222932 /* 02-14-2005 Sushant */
5713: nvl(bic.basis_type,1) basis_type
5714: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5715: bom_cto_order_lines_upg bcol2, -- MODEL
5716: mtl_system_items si1,
5717: mtl_system_items si2,
5718: bom_bill_of_materials bbm,
5719: bom_inventory_components bic, -- Components
5720: bom_inventory_components bic1, -- Parent

Line 5717: mtl_system_items si2,

5713: nvl(bic.basis_type,1) basis_type
5714: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5715: bom_cto_order_lines_upg bcol2, -- MODEL
5716: mtl_system_items si1,
5717: mtl_system_items si2,
5718: bom_bill_of_materials bbm,
5719: bom_inventory_components bic, -- Components
5720: bom_inventory_components bic1, -- Parent
5721: bom_explosion_temp bet

Line 5926: mtl_system_items msi_child,

5922: from bom_inventory_components ic1,
5923: bom_cto_order_lines_upg bcol1,
5924: bom_cto_order_lines_upg bcol2,
5925: bom_cto_order_lines_upg bcol3,
5926: mtl_system_items msi_child,
5927: mtl_system_items msi_parent
5928: where ic1.bill_sequence_id = (
5929: select common_bill_sequence_id
5930: from bom_bill_of_materials bbm

Line 5927: mtl_system_items msi_parent

5923: bom_cto_order_lines_upg bcol1,
5924: bom_cto_order_lines_upg bcol2,
5925: bom_cto_order_lines_upg bcol3,
5926: mtl_system_items msi_child,
5927: mtl_system_items msi_parent
5928: where ic1.bill_sequence_id = (
5929: select common_bill_sequence_id
5930: from bom_bill_of_materials bbm
5931: where organization_id = pOrgId

Line 5987: from mtl_system_items_kfv

5983: WriteToLog( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
5984:
5985:
5986: select concatenated_segments into v_model_item_name
5987: from mtl_system_items_kfv
5988: where inventory_item_id = pModelId
5989: and rownum = 1 ;
5990:
5991:

Line 6533: from mtl_system_items_kfv

6529: */
6530: END IF;
6531:
6532: select concatenated_segments into v_model_item_name
6533: from mtl_system_items_kfv
6534: where inventory_item_id = pModelId
6535: and rownum = 1 ;
6536:
6537:

Line 6659: from mtl_system_items msi

6655:
6656: select (ceil(nvl(msi.fixed_lead_time,0)
6657: + nvl(msi.variable_lead_time,0) * pQty))
6658: into pLeadTime
6659: from mtl_system_items msi
6660: where inventory_item_id = pModelId
6661: and organization_id = pOrgId;
6662:
6663: WriteToLog('Lead Time: ' || to_char(pLeadtime), 4);

Line 6807: from mtl_system_items

6803: and application_id = 401;
6804:
6805: lStmtNum := 285;
6806: select item_catalog_group_id into group_id
6807: from mtl_system_items
6808: where inventory_item_id = item_id
6809: and organization_id = org_id;
6810:
6811: WriteToLog('Bmlupid_update_item_desc:item_catalog_group_id : ' || group_id, 4);

Line 6839: update mtl_system_items

6835: end loop;
6836: close cc;
6837:
6838: if idx <> 0 then
6839: update mtl_system_items
6840: set description = cat_value
6841: where inventory_item_id = item_id;
6842: /*and organization_id = org_id; Bugfix 2163311 */
6843: /* start bugfix 1845141 */

Line 6844: update mtl_system_items_tl

6840: set description = cat_value
6841: where inventory_item_id = item_id;
6842: /*and organization_id = org_id; Bugfix 2163311 */
6843: /* start bugfix 1845141 */
6844: update mtl_system_items_tl
6845: set description = cat_value
6846: where inventory_item_id = item_id;
6847: /*and organization_id = org_id; Bugfix 2163311 */
6848: /* end bugfix 1845141 */