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

1206: BEGIN
1207: select CAL.CALENDAR_DATE
1208: into lEstRelDate
1209: from bom_calendar_dates cal,
1210: mtl_system_items msi,
1211: bom_cto_order_lines_upg bcolu,
1212: mtl_parameters mp
1213: where msi.organization_id = pOrgId
1214: and msi.inventory_item_id = pModelId

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

1424: bom_inventory_components ic1,
1425: bom_cto_order_lines_upg bcol1, -- Option
1426: bom_cto_order_lines_upg bcol2, -- Parent-Model
1427: bom_cto_order_lines_upg bcol3, -- Parent-component
1428: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1429: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1430: where ic1.bill_sequence_id = (
1431: select common_bill_sequence_id
1432: from bom_bill_of_materials bbm

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

1425: bom_cto_order_lines_upg bcol1, -- Option
1426: bom_cto_order_lines_upg bcol2, -- Parent-Model
1427: bom_cto_order_lines_upg bcol3, -- Parent-component
1428: mtl_system_items msi_child , /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1429: mtl_system_items msi_parent /* 02-14-2005 Sushant */ -- begin bugfix 1653881
1430: where ic1.bill_sequence_id = (
1431: select common_bill_sequence_id
1432: from bom_bill_of_materials bbm
1433: where organization_id = pOrgId

Line 1486: from mtl_system_items_kfv

1482:
1483: WriteToLog( 'SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
1484:
1485: select concatenated_segments into v_model_item_name
1486: from mtl_system_items_kfv
1487: where inventory_item_id = pModelId
1488: and rownum = 1 ;
1489:
1490:

Line 1669: mtl_system_items si1,

1665: cto_msutil_pub.bom_batch_id
1666: from
1667: bom_cto_order_lines_upg bcol1, -- component
1668: bom_cto_order_lines_upg bcol2, -- Model
1669: mtl_system_items si1,
1670: mtl_system_items si2,
1671: bom_bill_of_materials b,
1672: bom_inventory_components ic1
1673: where si1.organization_id = pOrgId

Line 1670: mtl_system_items si2,

1666: from
1667: bom_cto_order_lines_upg bcol1, -- component
1668: bom_cto_order_lines_upg bcol2, -- Model
1669: mtl_system_items si1,
1670: mtl_system_items si2,
1671: bom_bill_of_materials b,
1672: bom_inventory_components ic1
1673: where si1.organization_id = pOrgId
1674: and bcol1.inventory_item_id = si1.inventory_item_id

Line 1824: from mtl_system_items_kfv

1820: BEGIN
1821:
1822: select substrb(concatenated_segments,1,50)
1823: into v_config
1824: from mtl_system_items_kfv
1825: where organization_id = pOrgId
1826: and inventory_item_id = pConfigId ;
1827: WriteToLog('Config name is.. '|| v_config ,5);
1828:

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

1849: select substrb(msi.concatenated_segments,1,50),
1850: to_char(oel.line_number)||'.'||to_char(oel.shipment_number) ||decode(oel.option_number,NULL,NULL,'.'||to_char(option_number)),
1851: oeh.order_number
1852: into v_missed_item,v_missed_line_number,v_order_number
1853: from mtl_system_items_kfv msi, oe_order_lines_all oel,oe_order_headers_all oeh
1854: where msi.organization_id = oel.ship_from_org_id
1855: and msi.inventory_item_id = oel.inventory_item_id
1856: and oel.header_id = oeh.header_id
1857: and oel.line_id = v_missed_line_id;

Line 1893: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1889: /*select substrb(msi.concatenated_segments,1,50),
1890: 'Not Available' ,
1891: -1
1892: into v_missed_item,v_missed_line_number,v_order_number
1893: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1894: where msi.organization_id = bcolu.ship_from_org_id
1895: and msi.inventory_item_id = bcolu.inventory_item_id
1896: and bcolu.line_id = v_missed_line_id;
1897: */

Line 1904: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu

1900: select substrb(msi.concatenated_segments,1,50),
1901: 'Not Available' ,
1902: -1
1903: into v_missed_item,v_missed_line_number,v_order_number
1904: from mtl_system_items_kfv msi, bom_cto_order_lines_upg bcolu
1905: where msi.inventory_item_id = bcolu.inventory_item_id
1906: and bcolu.line_id = v_missed_line_id
1907: and rownum = 1;
1908: --End Bugfix 10240482

Line 1923: from mtl_system_items_kfv

1919: lStmtNum := 53;
1920: WriteToLog('Select model.. ' ,5);
1921: select substrb(concatenated_segments,1,50)
1922: into v_model
1923: from mtl_system_items_kfv
1924: where organization_id = pOrgId
1925: and inventory_item_id = pModelId ;
1926:
1927: lStmtNum := 54;

Line 2553: mtl_system_items si1,

2549: os1.routing_sequence_id,
2550: l_batch_id
2551: from
2552: bom_cto_order_lines_upg bcol1,
2553: mtl_system_items si1,
2554: bom_operational_routings or1,
2555: bom_operation_sequences os1
2556: where bcol1.line_id = pLineId
2557: and bcol1.inventory_item_id = pModelId

Line 2587: mtl_system_items msi,

2583: l_batch_id
2584: from
2585: bom_cto_order_lines_upg bcol1, -- components
2586: bom_cto_order_lines_upg bcol2, -- parent models or option classes
2587: mtl_system_items msi,
2588: bom_inventory_components ic1,
2589: bom_bill_of_materials b1,
2590: bom_operational_routings or1,
2591: bom_operation_sequences os1

Line 2652: mtl_system_items si2,

2648: l_batch_id
2649: from
2650: bom_operation_sequences os1,
2651: bom_operational_routings or1,
2652: mtl_system_items si2,
2653: bom_inventory_components ic1,
2654: bom_bill_of_materials b1,
2655: mtl_system_items si1
2656: where si1.organization_id = pOrgId

Line 2655: mtl_system_items si1

2651: bom_operational_routings or1,
2652: mtl_system_items si2,
2653: bom_inventory_components ic1,
2654: bom_bill_of_materials b1,
2655: mtl_system_items si1
2656: where si1.organization_id = pOrgId
2657: and si1.inventory_item_id = pModelId
2658: and si1.bom_item_type = 1 /* model */
2659: and b1.organization_id = si1.organization_id

Line 2976: mtl_system_items si1,

2972: os1.operation_seq_num,
2973: nvl(os1.operation_type,1),
2974: os1.routing_sequence_id
2975: from
2976: mtl_system_items si1,
2977: bom_cto_order_lines_upg bcol,
2978: bom_operational_routings or1,
2979: bom_operation_sequences os1
2980: where bcol.parent_ato_line_id = pLineId

Line 3069: mtl_system_items si2,

3065: os1.routing_sequence_id
3066: from
3067: bom_operation_sequences os1,
3068: bom_operational_routings or1,
3069: mtl_system_items si2,
3070: bom_inventory_components ic1,
3071: bom_bill_of_materials b1,
3072: mtl_system_items si1,
3073: bom_cto_order_lines_upg bcol /* Model or option class */

Line 3072: mtl_system_items si1,

3068: bom_operational_routings or1,
3069: mtl_system_items si2,
3070: bom_inventory_components ic1,
3071: bom_bill_of_materials b1,
3072: mtl_system_items si1,
3073: bom_cto_order_lines_upg bcol /* Model or option class */
3074: where bcol.parent_ato_line_id = pLineId
3075: and bcol.component_sequence_id is not null
3076: and bcol.ordered_quantity <> 0

Line 3593: from mtl_System_items

3589: else
3590: lstmtNum := 411;
3591: Select serial_number_control_code
3592: into l_ser_code
3593: from mtl_System_items
3594: where inventory_item_id = pModelId
3595: and organization_id =pOrgId;
3596:
3597: WriteToLog('serial_number_control_code of model is '||l_ser_code , 4);

Line 4045: from mtl_system_items

4041: WriteToLog( 'will not populated message CTO_CLUB_COMP_ERROR');
4042: END IF;
4043: select segment1 into
4044: l_model_name
4045: from mtl_system_items
4046: where inventory_item_id = pmodelid
4047: and organization_id = porgid;
4048:
4049:

Line 4052: from mtl_system_items

4048:
4049:
4050: select segment1 into
4051: l_comp_name
4052: from mtl_system_items
4053: where inventory_item_id = club_comp_rec.item_id
4054: and organization_id = porgid;
4055:
4056: select organization_name

Line 4667: mtl_system_items msi

4663: b.plan_level, --isp bom
4664: b.model_comp_seq_id --isp bom
4665: , decode(b.basis_type,1,null,b.basis_type) /* LBM change */
4666: from bom_inventory_comps_interface b,
4667: mtl_system_items msi
4668: where b.bill_sequence_id = lConfigBillId
4669: and b.component_item_id = msi.inventory_item_id
4670: and msi.organization_id = pOrgId;
4671:

Line 5209: SELECT 'x' FROM MTL_SYSTEM_ITEMS

5205: -- user exists clause instead of using not in for performance
5206: -- reason
5207: and not exists
5208: (
5209: SELECT 'x' FROM MTL_SYSTEM_ITEMS
5210: WHERE ORGANIZATION_ID = pOrgId
5211: AND BC1.COMPONENT_ITEM_ID = INVENTORY_ITEM_ID
5212: AND BASE_ITEM_ID IS NOT NULL
5213: AND BOM_ITEM_TYPE = 4

Line 5225: the MTL_SYSTEM_ITEMS

5221:
5222:
5223: /*---------------------------------------------------------------------+
5224: Update descriptions of the config items in
5225: the MTL_SYSTEM_ITEMS
5226: +----------------------------------------------------------------------*/
5227:
5228: lStmtNum := 350;
5229: xTableName := 'MTL_SYSTEM_ITMES';

Line 5747: mtl_system_items msi

5743: AND NVL(bos4.operation_type,1) = NVL(bos2.operation_type, 1)
5744: AND bos1.routing_sequence_id = ( /* find the model routing */
5745: select routing_sequence_id
5746: from bom_operational_routings bor,
5747: mtl_system_items msi
5748: where brif.assembly_item_id = msi.inventory_item_id
5749: and brif.organization_id = msi.organization_id
5750: and bor.assembly_item_id = msi.base_item_id
5751: and bor.organization_id = msi.organization_id

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

5870: xErrorMessage out NOCOPY VARCHAR2,
5871: xMessageName out NOCOPY VARCHAR2)
5872: RETURN INTEGER IS
5873:
5874: CURSOR c_incl_items_all_level ( xOrgId mtl_system_items.organization_id%TYPE,
5875: xLineId bom_cto_order_lines_upg.line_id%TYPE,
5876: xConfigBillId bom_inventory_components.bill_sequence_id%TYPE ,
5877: xSchShpdt date,
5878: xEstReldt date ) IS

Line 5925: mtl_system_items si1,

5921: nvl(bic.disable_date,g_futuredate) dis_date, -- 3222932 /* 02-14-2005 Sushant */
5922: nvl(bic.basis_type,1) basis_type
5923: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5924: bom_cto_order_lines_upg bcol2, -- MODEL
5925: mtl_system_items si1,
5926: mtl_system_items si2,
5927: bom_bill_of_materials bbm,
5928: bom_inventory_components bic, -- Components
5929: bom_inventory_components bic1, -- Parent

Line 5926: mtl_system_items si2,

5922: nvl(bic.basis_type,1) basis_type
5923: from bom_cto_order_lines_upg bcol1, -- COMPONENT
5924: bom_cto_order_lines_upg bcol2, -- MODEL
5925: mtl_system_items si1,
5926: mtl_system_items si2,
5927: bom_bill_of_materials bbm,
5928: bom_inventory_components bic, -- Components
5929: bom_inventory_components bic1, -- Parent
5930: bom_explosion_temp bet

Line 6135: mtl_system_items msi_child,

6131: from bom_inventory_components ic1,
6132: bom_cto_order_lines_upg bcol1,
6133: bom_cto_order_lines_upg bcol2,
6134: bom_cto_order_lines_upg bcol3,
6135: mtl_system_items msi_child,
6136: mtl_system_items msi_parent
6137: where ic1.bill_sequence_id = (
6138: select common_bill_sequence_id
6139: from bom_bill_of_materials bbm

Line 6136: mtl_system_items msi_parent

6132: bom_cto_order_lines_upg bcol1,
6133: bom_cto_order_lines_upg bcol2,
6134: bom_cto_order_lines_upg bcol3,
6135: mtl_system_items msi_child,
6136: mtl_system_items msi_parent
6137: where ic1.bill_sequence_id = (
6138: select common_bill_sequence_id
6139: from bom_bill_of_materials bbm
6140: where organization_id = pOrgId

Line 6196: from mtl_system_items_kfv

6192: WriteToLog( 'Inherit_op_seq_ml:: SHOULD Raise Exception for Zero QTY Count ' || v_zero_qty_count , 1 ) ;
6193:
6194:
6195: select concatenated_segments into v_model_item_name
6196: from mtl_system_items_kfv
6197: where inventory_item_id = pModelId
6198: and rownum = 1 ;
6199:
6200:

Line 6745: from mtl_system_items_kfv

6741: */
6742: END IF;
6743:
6744: select concatenated_segments into v_model_item_name
6745: from mtl_system_items_kfv
6746: where inventory_item_id = pModelId
6747: and rownum = 1 ;
6748:
6749:

Line 6871: from mtl_system_items msi

6867:
6868: select (ceil(nvl(msi.fixed_lead_time,0)
6869: + nvl(msi.variable_lead_time,0) * pQty))
6870: into pLeadTime
6871: from mtl_system_items msi
6872: where inventory_item_id = pModelId
6873: and organization_id = pOrgId;
6874:
6875: WriteToLog('Lead Time: ' || to_char(pLeadtime), 4);

Line 7019: from mtl_system_items

7015: and application_id = 401;
7016:
7017: lStmtNum := 285;
7018: select item_catalog_group_id into group_id
7019: from mtl_system_items
7020: where inventory_item_id = item_id
7021: and organization_id = org_id;
7022:
7023: WriteToLog('Bmlupid_update_item_desc:item_catalog_group_id : ' || group_id, 4);

Line 7051: update mtl_system_items

7047: end loop;
7048: close cc;
7049:
7050: if idx <> 0 then
7051: update mtl_system_items
7052: set description = cat_value
7053: where inventory_item_id = item_id;
7054: /*and organization_id = org_id; Bugfix 2163311 */
7055: /* start bugfix 1845141 */

Line 7056: update mtl_system_items_tl

7052: set description = cat_value
7053: where inventory_item_id = item_id;
7054: /*and organization_id = org_id; Bugfix 2163311 */
7055: /* start bugfix 1845141 */
7056: update mtl_system_items_tl
7057: set description = cat_value
7058: where inventory_item_id = item_id;
7059: /*and organization_id = org_id; Bugfix 2163311 */
7060: /* end bugfix 1845141 */