APPS.EAM_ASSET_NUMBER_PVT dependencies on MTL_PARAMETERS

Line 233: from mtl_parameters

229: l_instance_rec.vld_organization_id := p_organization_id; -- replace
230:
231: select master_organization_id
232: into l_master_organization_id
233: from mtl_parameters
234: where organization_id = p_organization_id;
235:
236: l_instance_rec.inv_master_organization_id := l_master_organization_id; -- replace
237: l_instance_rec.serial_number := p_serial_number; -- replace

Line 1604: FROM mtl_parameters

1600: --if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1601:
1602: /* bug 5177526 : Need to pass maint org id */
1603: SELECT maint_organization_id INTO l_count
1604: FROM mtl_parameters
1605: WHERE organization_id = p_organization_id;
1606:
1607: if (p_from_public_api = 'N') then
1608: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);

Line 1746: from mtl_parameters

1742:
1743: x_ser_num_in_item_id := FALSE;
1744: select serial_number_type
1745: into l_serial_number_type
1746: from mtl_parameters
1747: where organization_id = p_organization_id;
1748:
1749: mtl_serial_check.SNUniqueCheck(
1750: p_api_version => 0.9,

Line 1848: mtl_parameters mp,

1844: mtl_serial_numbers msn,
1845: fa_additions fa,
1846: csi_i_assets cia,
1847: mtl_system_items msi,
1848: mtl_parameters mp,
1849: eam_org_maint_defaults eomd,
1850: mtl_system_items msi_prod,
1851: mtl_serial_numbers msn_prod,
1852: mtl_parameters mp_prod

Line 1852: mtl_parameters mp_prod

1848: mtl_parameters mp,
1849: eam_org_maint_defaults eomd,
1850: mtl_system_items msi_prod,
1851: mtl_serial_numbers msn_prod,
1852: mtl_parameters mp_prod
1853: where cii.last_vld_organization_id = msn.current_organization_id
1854: and cii.inventory_item_id=msn.inventory_item_id
1855: and cii.serial_number=msn.serial_number
1856: and cii.last_vld_organization_id = p_organization_id