DBA Data[Home] [Help]

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

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

Line 382: mtl_system_items msi_b

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

Line 1140: FROM mtl_system_items_kfv kfv, mtl_parameters mp

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

Line 1183: FROM mtl_system_items_kfv kfv, mtl_parameters mp

1179: begin
1180: SELECT substrb(kfv.concatenated_segments,1,35),
1181: mp.organization_code
1182: INTO l_config_description, l_org_code
1183: FROM mtl_system_items_kfv kfv, mtl_parameters mp
1184: WHERE kfv.inventory_item_id = fail_item_arr(curr_count).cfg_item_id
1185: AND kfv.organization_id = fail_item_arr(curr_count).cfg_org_id
1186: AND kfv.organization_id = mp.organization_id;
1187:

Line 1245: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;

1241:
1242: v_t_sourcing_info CTO_MSUTIL_PUB.sourcing_info;
1243: v_buy_traversed boolean := false ;
1244: v_source_type mrp_sources_v.source_type%type ;
1245: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1246:
1247: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1248: l_source_type mrp_sources_v.source_type%type ;
1249: l_curr_assg_type mrp_sources_v.assignment_type%type ;

Line 1547: FROM MTL_SYSTEM_ITEMS

1543: BEGIN
1544:
1545: SELECT planning_make_buy_code
1546: INTO l_make_buy_code
1547: FROM MTL_SYSTEM_ITEMS
1548: WHERE inventory_item_id = p_config_item_id
1549: AND organization_id = p_organization_id ;
1550:
1551: EXCEPTION