APPS.INVIDSCS dependencies on MTL_PARAMETERS

Line 214: from mtl_parameters p

210: select
211: p.organization_id
212: BULK COLLECT INTO
213: l_organizations_rec
214: from mtl_parameters p
215: where p.master_organization_id = current_master_org_id
216: and p.organization_id <> current_master_org_id
217: and exists
218: (select 'x'

Line 309: (select p.organization_id from mtl_parameters p

305: where c.inventory_item_id = current_inv_item_id
306: and c.category_set_id = current_cat_set_id
307: and c.category_id = old_cat_id
308: and c.organization_id in
309: (select p.organization_id from mtl_parameters p
310: where p.master_organization_id =
311: current_master_org_id
312: and exists (select 'x' from mtl_system_items i
313: where i.inventory_item_id =

Line 367: from mtl_parameters

363: inventory_item_id = current_inv_item_id and
364: organization_id <> current_org_id and
365: organization_id in
366: ( select organization_id
367: from mtl_parameters
368: where
369: master_organization_id = current_master_org_id
370: )
371: ;

Line 473: from mtl_parameters

469: --dbms_output.put_line ( 'Inside get_costing_values ' );
470:
471: select primary_cost_method
472: into tmp_cost_method
473: from mtl_parameters
474: where organization_id = tmp_organization_id;
475:
476: begin
477: select lot_size, shrinkage_rate

Line 537: from mtl_parameters p

533: and c.category_set_id = current_cat_set_id
534: and c.category_id = current_cat_id
535: and c.organization_id in
536: (select p.organization_id
537: from mtl_parameters p
538: where p.master_organization_id = current_master_org_id)
539: RETURNING organization_id
540: BULK COLLECT INTO
541: l_organizations_rec;