APPS.CTO_COST_ROLLUP_CONC_PK dependencies on BOM_PARAMETERS

Line 152: from bom_parameters bp

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
153: where bp.organization_id =msi.organization_id);
154:
155:
156: -- rkaza. 04/28/2005.

Line 264: from bom_parameters bp

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 <>
263: ( select bom_delete_status_code
264: from bom_parameters bp
265: where bp.organization_id =msi.organization_id
266: )
267: and (p_model_id is null or
268: msi.base_item_id = p_model_id)

Line 286: ' from bom_parameters bp ' ||

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 <> ' ||
285: ' ( select bom_delete_status_code ' ||
286: ' from bom_parameters bp ' ||
287: ' where bp.organization_id =msi.organization_id ' ||
288: ' )' ||
289: --Bugfix 12957444
290: ' and msi.costing_enabled_flag = ''Y'' ';

Line 393: from bom_parameters bp

389: and msi.organization_id = msi_b.organization_id
390: and bcol_upg.inventory_item_id = msi_b.inventory_item_id
391: and msi.inventory_item_status_code <>
392: ( select bom_delete_status_code
393: from bom_parameters bp
394: where bp.organization_id = msi.organization_id
395: )
396: ORDER BY 1;
397: end if;