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

Line 148: from mtl_system_items msi

144: config_cv ConfigCurTyp;
145:
146: cursor cfg_org_cur ( x_config_item number ) is
147: select msi.organization_id
148: from mtl_system_items msi
149: where msi.inventory_item_id = x_config_item
150: and msi.inventory_item_status_code <>
151: ( select nvl(bom_delete_status_code,'-99') -- bug fix 5276658
152: from bom_parameters bp

Line 161: , mtl_system_items msi

157: -- adding organization_id join between bet and msi for perf improvement
158: cursor child_config_cur(xgrp_id bom_explosion_temp.group_id%TYPE ) is
159: select distinct bet.component_item_id,msi_b.config_orgs,bet.plan_level
160: from bom_explosion_temp bet
161: , mtl_system_items msi
162: , mtl_system_items msi_b
163: where bet.group_id = xgrp_id
164: and bet.component_item_id = msi.inventory_item_id
165: and bet.organization_id = msi.organization_id

Line 162: , mtl_system_items msi_b

158: cursor child_config_cur(xgrp_id bom_explosion_temp.group_id%TYPE ) is
159: select distinct bet.component_item_id,msi_b.config_orgs,bet.plan_level
160: from bom_explosion_temp bet
161: , mtl_system_items msi
162: , mtl_system_items msi_b
163: where bet.group_id = xgrp_id
164: and bet.component_item_id = msi.inventory_item_id
165: and bet.organization_id = msi.organization_id
166: and msi_b.inventory_item_id = msi.base_item_id

Line 257: from mtl_system_items msi,

253: Rollup Program has performance issues. */
254: /*OPEN config_cv FOR
255: select distinct msi.inventory_item_id,
256: nvl(msi_b.config_orgs,'1')
257: from mtl_system_items msi,
258: mtl_system_items msi_b
259: where msi.base_item_id is not null
260: and msi.base_item_id = msi_b.inventory_item_id
261: and msi.organization_id = msi_b.organization_id

Line 258: mtl_system_items msi_b

254: /*OPEN config_cv FOR
255: select distinct msi.inventory_item_id,
256: nvl(msi_b.config_orgs,'1')
257: from mtl_system_items msi,
258: mtl_system_items msi_b
259: where msi.base_item_id is not null
260: and msi.base_item_id = msi_b.inventory_item_id
261: and msi.organization_id = msi_b.organization_id
262: and msi.inventory_item_status_code <>

Line 279: ' from mtl_system_items msi, ' ||

275: ORDER BY 1; */
276: --Bugfix 5907413: Adding Dynamic SQL.
277: sql_stmt := 'select distinct msi.inventory_item_id, ' ||
278: ' nvl(msi_b.config_orgs,''1'') ' ||
279: ' from mtl_system_items msi, ' ||
280: ' mtl_system_items msi_b ' ||
281: ' where msi.base_item_id is not null ' ||
282: ' and msi.base_item_id = msi_b.inventory_item_id ' ||
283: ' and msi.organization_id = msi_b.organization_id ' ||

Line 280: ' mtl_system_items msi_b ' ||

276: --Bugfix 5907413: Adding Dynamic SQL.
277: sql_stmt := 'select distinct msi.inventory_item_id, ' ||
278: ' nvl(msi_b.config_orgs,''1'') ' ||
279: ' from mtl_system_items msi, ' ||
280: ' mtl_system_items msi_b ' ||
281: ' where msi.base_item_id is not null ' ||
282: ' and msi.base_item_id = msi_b.inventory_item_id ' ||
283: ' and msi.organization_id = msi_b.organization_id ' ||
284: ' and msi.inventory_item_status_code <> ' ||

Line 383: mtl_system_items msi,

379: OPEN config_cv FOR
380: select distinct msi.inventory_item_id,
381: nvl( msi_b.config_orgs , '1')
382: from bom_cto_order_lines_upg bcol_upg,
383: mtl_system_items msi,
384: mtl_system_items msi_b
385: where bcol_upg.line_id = bcol_upg.ato_line_id /* bugfix 3777922 */
386: and bcol_upg.config_item_id = msi.inventory_item_id
387: and msi.base_item_id is not null

Line 384: mtl_system_items msi_b

380: select distinct msi.inventory_item_id,
381: nvl( msi_b.config_orgs , '1')
382: from bom_cto_order_lines_upg bcol_upg,
383: mtl_system_items msi,
384: mtl_system_items msi_b
385: where bcol_upg.line_id = bcol_upg.ato_line_id /* bugfix 3777922 */
386: and bcol_upg.config_item_id = msi.inventory_item_id
387: and msi.base_item_id is not null
388: and msi.base_item_id = msi_b.inventory_item_id

Line 1101: FROM mtl_system_items_kfv kfv, mtl_parameters mp

1097: begin
1098: SELECT substrb(kfv.concatenated_segments,1,35),
1099: mp.organization_code
1100: INTO l_config_description, l_org_code
1101: FROM mtl_system_items_kfv kfv, mtl_parameters mp
1102: WHERE kfv.inventory_item_id = succ_item_arr(curr_count).cfg_item_id
1103: AND kfv.organization_id = succ_item_arr(curr_count).cfg_org_id
1104: AND kfv.organization_id = mp.organization_id;
1105:

Line 1141: FROM mtl_system_items_kfv kfv, mtl_parameters mp

1137: begin
1138: SELECT substrb(kfv.concatenated_segments,1,35),
1139: mp.organization_code
1140: INTO l_config_description, l_org_code
1141: FROM mtl_system_items_kfv kfv, mtl_parameters mp
1142: WHERE kfv.inventory_item_id = fail_item_arr(curr_count).cfg_item_id
1143: AND kfv.organization_id = fail_item_arr(curr_count).cfg_org_id
1144: AND kfv.organization_id = mp.organization_id;
1145:

Line 1199: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;

1195:
1196: v_t_sourcing_info CTO_MSUTIL_PUB.sourcing_info;
1197: v_buy_traversed boolean := false ;
1198: v_source_type mrp_sources_v.source_type%type ;
1199: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1200:
1201: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1202: l_source_type mrp_sources_v.source_type%type ;
1203: l_curr_assg_type mrp_sources_v.assignment_type%type ;

Line 1501: FROM MTL_SYSTEM_ITEMS

1497: BEGIN
1498:
1499: SELECT planning_make_buy_code
1500: INTO l_make_buy_code
1501: FROM MTL_SYSTEM_ITEMS
1502: WHERE inventory_item_id = p_config_item_id
1503: AND organization_id = p_organization_id ;
1504:
1505: EXCEPTION