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 310: (select p.organization_id from mtl_parameters p

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

Line 368: from mtl_parameters

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

Line 474: from mtl_parameters

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

Line 538: from mtl_parameters p

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