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:
290: IF p_model_id is not null THEN

Line 391: from bom_parameters bp

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