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

Line 120: mtl_system_items_kfv msi

116:
117: CURSOR c_configs(l_ato_line_id number) IS
118: select substrb(concatenated_segments,1,50) config_name
119: from bom_cto_order_lines_upg bcolu,
120: mtl_system_items_kfv msi
121: where bcolu.ato_line_id = l_ato_line_id
122: and bcolu.config_item_id is not null
123: and bcolu.config_item_id = msi.inventory_item_id
124: and bcolu.ship_from_org_id = msi.organization_id;

Line 451: update mtl_system_items_b msic

447:
448: If p_upgrade_mode = 2 Then
449: WriteToLog('Updating ATP attributes for configs in existing orgs');
450:
451: update mtl_system_items_b msic
452: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
453: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
454: from mtl_system_items_b msim
455: where msim.inventory_item_id = msic.base_item_id

Line 454: from mtl_system_items_b msim

450:
451: update mtl_system_items_b msic
452: set (msic.atp_components_flag,msic.atp_flag) = (select CTO_CONFIG_ITEM_PK.evaluate_atp_attributes(msim.atp_flag,
453: msim.atp_components_flag),CTO_CONFIG_ITEM_PK.get_atp_flag
454: from mtl_system_items_b msim
455: where msim.inventory_item_id = msic.base_item_id
456: and msim.organization_id = msic.organization_id)
457: where msic.inventory_item_id in
458: (

Line 465: from mtl_system_items_b msim1

461: where status = 'BCSO'
462: and config_item_id is not null
463: )
464: and exists (select 'x'
465: from mtl_system_items_b msim1
466: where msim1.inventory_item_id = msic.base_item_id
467: and msim1.organization_id = msic.organization_id);
468:
469: WriteToLog('Number of Configs updated for ATP attributes ='||sql%rowcount);

Line 1098: from mtl_system_items msi,

1094: select /*+ INDEX ( BOM_CTO_ORDER_LINES_UPG BOM_CTO_ORDER_LINES_UPG_N2 ) */
1095: bcolu.config_item_id cfg_item_id,
1096: bcolu.inventory_item_id model_item_id,
1097: msi.organization_id src_org_id
1098: from mtl_system_items msi,
1099: bom_cto_order_lines_upg bcolu
1100: where bcolu.config_item_id is not null
1101: and bcolu.status = 'BCSO'
1102: and msi.inventory_item_id = bcolu.config_item_id

Line 1108: AND entity_name = 'MTL_SYSTEM_ITEMS');

1104: (SELECT 'x'
1105: FROM FND_ATTACHED_DOCUMENTS
1106: WHERE pk1_value = to_char(msi.organization_id)
1107: AND pk2_value = to_char(msi.inventory_item_id)
1108: AND entity_name = 'MTL_SYSTEM_ITEMS');
1109:
1110:
1111:
1112: Type number_tbl_type IS TABLE OF number INDEX BY BINARY_INTEGER;

Line 1156: insert into mtl_system_items_tl (

1152: WriteToLog('Entering Update_Item_Data', 3);
1153: lStmtNumber := 10;
1154: xReturnStatus := FND_API.G_RET_STS_SUCCESS;
1155:
1156: insert into mtl_system_items_tl (
1157: inventory_item_id,
1158: organization_id,
1159: language,
1160: source_lang,

Line 1181: mtl_system_items_tl m,

1177: sysdate,
1178: gUserId, --created_by
1179: gLoginId --last_update_login
1180: from
1181: mtl_system_items_tl m,
1182: bom_cto_src_orgs bcso,
1183: bom_cto_order_lines_upg bcolu,
1184: fnd_languages l
1185: where bcolu.config_item_id is not null

Line 1195: from mtl_system_items_tl t

1191: and l.installed_flag In ('I', 'B')
1192: and l.language_code = m.language
1193: and NOT EXISTS
1194: (select NULL
1195: from mtl_system_items_tl t
1196: where t.inventory_item_id = bcolu.config_item_id
1197: and t.organization_id = bcso.organization_id
1198: and t.language = l.language_code );
1199:

Line 1200: WriteToLog('Inserted rows into mtl_system_items_tl:: '||sql%rowcount,2);

1196: where t.inventory_item_id = bcolu.config_item_id
1197: and t.organization_id = bcso.organization_id
1198: and t.language = l.language_code );
1199:
1200: WriteToLog('Inserted rows into mtl_system_items_tl:: '||sql%rowcount,2);
1201:
1202: lStmtNumber := 20;
1203: insert into MTL_PENDING_ITEM_STATUS (
1204: inventory_item_id,

Line 1234: from mtl_system_items m,

1230: null,
1231: null,
1232: sysdate,
1233: null -- req_id
1234: from mtl_system_items m,
1235: bom_cto_src_orgs bcso,
1236: bom_cto_order_lines_upg bcolu
1237: where bcolu.config_item_id is not null
1238: and bcolu.status = 'BCSO'

Line 1300: mtl_system_items m

1296: MTL_ITEM_REVISIONS_B_S.nextval, -- 3338108 --l_rev_id, --revision_id is generated from sequence
1297: mp1.starting_revision --3340844
1298: from
1299: mtl_parameters mp1,
1300: mtl_system_items m
1301: where m.inventory_item_id = v_bcolu_cfg.config_item_id
1302: and m.organization_id = mp1.organization_id
1303: and NOT EXISTS
1304: (select NULL

Line 1339: mtl_system_items_tl m,

1335: sysdate,
1336: gUserId, --created_by
1337: gLoginId --last_update_login
1338: from
1339: mtl_system_items_tl m,
1340: bom_cto_src_orgs bcso,
1341: fnd_languages l,
1342: mtl_item_revisions_b mr --3338108
1343: where m.inventory_item_id = v_bcolu_cfg.inventory_item_id

Line 1379: --removed un-necessary join on mtl_system_items

1375:
1376: --performance bugfix4905887 shared memroy 1MB (sqlid :16104932 )
1377: --Removed comments to max possible
1378: --bsco is a mergable view now
1379: --removed un-necessary join on mtl_system_items
1380: --Removed a Distinct clause in IN sub-query
1381:
1382: select bcolu.config_item_id,
1383: C.organization_id, -- bug 4172300

Line 1592: mtl_system_items S,

1588: C.attribute15
1589: from
1590: mtl_parameters MP1,
1591: cst_item_costs C,
1592: mtl_system_items S,
1593: bom_cto_src_orgs bcso,
1594: bom_cto_order_lines_upg bcolu
1595: where bcolu.config_item_id is not null
1596: and bcolu.status = 'BCSO'

Line 1815: mtl_system_items S,

1811: C.attribute15
1812: from
1813: mtl_parameters MP1,
1814: cst_item_costs C,
1815: mtl_system_items S,
1816: bom_cto_src_orgs bcso,
1817: bom_cto_order_lines_upg bcolu
1818: where bcolu.config_item_id is not null
1819: and bcolu.status = 'BCSO'

Line 1978: mtl_system_items S,

1974: C.attribute15
1975: from
1976: mtl_parameters MP1,
1977: cst_item_cost_details C,
1978: mtl_system_items S,
1979: bom_cto_src_orgs bcso,
1980: bom_cto_order_lines_upg bcolu
1981: where bcolu.config_item_id is not null
1982: and bcolu.status = 'BCSO'

Line 2100: mtl_system_items S,

2096: C.attribute15
2097: from
2098: mtl_parameters MP1,
2099: cst_item_cost_details C,
2100: mtl_system_items S,
2101: bom_cto_src_orgs bcso,
2102: bom_cto_order_lines_upg bcolu
2103: where bcolu.config_item_id is not null
2104: and bcolu.status = 'BCSO'

Line 2202: from mtl_system_items s,

2198: NULL, -- program_application_id
2199: NULL, -- program_id
2200: SYSDATE, -- program_update_date
2201: NULL -- request_id
2202: from mtl_system_items s,
2203: mtl_descr_element_values D,
2204: mtl_descriptive_elements E,
2205: bom_cto_order_lines_upg bcolu
2206: where bcolu.config_item_id is not null

Line 2855: mtl_system_items_tl mtl

2851: l.language_code,
2852: userenv('lang')
2853: FROM fnd_languages l,
2854: mtl_cross_references_b mtl_cross,
2855: mtl_system_items_tl mtl
2856: WHERE mtl_cross.inventory_item_id = t_cfg_item_id(i)
2857: AND mtl_cross.inventory_item_id = mtl.inventory_item_id
2858: AND mtl_cross.organization_id = mtl.organization_id
2859: AND l.language_code = mtl.language

Line 2994: X_from_entity_name => 'MTL_SYSTEM_ITEMS',

2990: lStmtNumber := 200;
2991: FOR v_get_org_id in c_get_org_id LOOP
2992:
2993: fnd_attached_documents2_pkg.copy_attachments (
2994: X_from_entity_name => 'MTL_SYSTEM_ITEMS',
2995: X_from_pk1_value => v_get_org_id.src_org_id,
2996: X_from_pk2_value => v_get_org_id.model_item_id,
2997: X_from_pk3_value => NULL,
2998: X_from_pk4_value => NULL,

Line 3000: X_to_entity_name => 'MTL_SYSTEM_ITEMS',

2996: X_from_pk2_value => v_get_org_id.model_item_id,
2997: X_from_pk3_value => NULL,
2998: X_from_pk4_value => NULL,
2999: X_from_pk5_value => NULL,
3000: X_to_entity_name => 'MTL_SYSTEM_ITEMS',
3001: X_to_pk1_value => v_get_org_id.src_org_id,
3002: X_to_pk2_value => v_get_org_id.cfg_item_id,
3003: X_to_pk3_value => NULL,
3004: X_to_pk4_value => NULL,

Line 3114: insert into mtl_system_items_b

3110:
3111: -- Bug 9223457.added additional attribute columns added in 12.1
3112: -- for mtl_sys_items.pdube
3113:
3114: insert into mtl_system_items_b
3115: (inventory_item_id,
3116: organization_id,
3117: last_update_date,
3118: last_updated_by,

Line 3807: mtl_system_items_b m, -- model

3803: 2
3804:
3805: from
3806: mtl_parameters mp1,
3807: mtl_system_items_b m, -- model
3808: mtl_system_items_b c, -- config
3809: bom_cto_src_orgs bcso,
3810: bom_cto_order_lines_upg bcolu
3811: where bcolu.config_item_id is not null

Line 3808: mtl_system_items_b c, -- config

3804:
3805: from
3806: mtl_parameters mp1,
3807: mtl_system_items_b m, -- model
3808: mtl_system_items_b c, -- config
3809: bom_cto_src_orgs bcso,
3810: bom_cto_order_lines_upg bcolu
3811: where bcolu.config_item_id is not null
3812: and bcolu.status = 'BCSO'

Line 3816: and c.organization_id = ( select organization_id from mtl_system_items

3812: and bcolu.status = 'BCSO'
3813: and m.inventory_item_id = bcolu.inventory_item_id
3814: -- get config item row for any one org
3815: and c.inventory_item_id = bcolu.config_item_id
3816: and c.organization_id = ( select organization_id from mtl_system_items
3817: where inventory_item_id = c.inventory_item_id and rownum = 1) /*BUGFIX 3576040 */
3818: -- config is not pc in any orgs
3819: and not exists
3820: (select 'pc'

Line 3821: from mtl_system_items msi1

3817: where inventory_item_id = c.inventory_item_id and rownum = 1) /*BUGFIX 3576040 */
3818: -- config is not pc in any orgs
3819: and not exists
3820: (select 'pc'
3821: from mtl_system_items msi1
3822: where msi1.inventory_item_id = bcolu.config_item_id
3823: and nvl(msi1.auto_created_config_flag,'N') = 'N')
3824: and bcso.model_item_id = bcolu.inventory_item_id
3825: and bcso.line_id = bcolu.line_id

Line 3830: from mtl_system_items_b

3826: and m.organization_id = mp1.organization_id
3827: and mp1.organization_id = bcso.organization_id
3828: and NOT EXISTS
3829: (select NULL
3830: from mtl_system_items_b
3831: where inventory_item_id = bcolu.config_item_id
3832: and organization_id = mp1.organization_id);
3833:
3834: WriteToLog('Items created::'||sql%rowcount, 2);

Line 3898: insert into mtl_system_items_b

3894: --perf bugfix 4905887 (sql id 16105473)
3895: --Removed comments to extent possible
3896:
3897: lStmtNumber := 20;
3898: insert into mtl_system_items_b
3899: (inventory_item_id,
3900: organization_id,
3901: last_update_date,
3902: last_updated_by,

Line 4591: mtl_system_items_b m, -- model

4587: 3,
4588: 2
4589:
4590: from
4591: mtl_system_items_b m, -- model
4592: mtl_system_items_b config, -- config
4593: bom_cto_src_orgs bcso,
4594: bom_cto_order_lines_upg bcolu
4595: where bcolu.config_item_id is not null

Line 4592: mtl_system_items_b config, -- config

4588: 2
4589:
4590: from
4591: mtl_system_items_b m, -- model
4592: mtl_system_items_b config, -- config
4593: bom_cto_src_orgs bcso,
4594: bom_cto_order_lines_upg bcolu
4595: where bcolu.config_item_id is not null
4596: and bcolu.status = 'BCSO'

Line 4604: from mtl_system_items msi1

4600: and config.organization_id = bcolu.ship_from_org_id
4601: -- config is pc in atleast one orgs
4602: and exists
4603: (select 'pc'
4604: from mtl_system_items msi1
4605: where msi1.inventory_item_id = bcolu.config_item_id
4606: and nvl(msi1.auto_created_config_flag,'N') = 'N')
4607: and bcso.model_item_id = bcolu.inventory_item_id
4608: and bcso.line_id = bcolu.line_id

Line 4612: from mtl_system_items_b

4608: and bcso.line_id = bcolu.line_id
4609: and m.organization_id = bcso.organization_id
4610: and NOT EXISTS
4611: (select NULL
4612: from mtl_system_items_b
4613: where inventory_item_id = bcolu.config_item_id
4614: and organization_id = bcso.organization_id);
4615:
4616: WriteToLog('PC Items created::'||sql%rowcount, 2);