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 1596: FROM mtl_parameters

1592: --if (p_owning_department_id is not null OR p_accounting_class_code is not null OR p_area_id is not null) then
1593:
1594: /* bug 5177526 : Need to pass maint org id */
1595: SELECT maint_organization_id INTO l_count
1596: FROM mtl_parameters
1597: WHERE organization_id = p_organization_id;
1598:
1599: if (p_from_public_api = 'N') then
1600: l_owning_department_id := nvl(p_owning_department_id,FND_API.G_MISS_NUM);

Line 1719: from mtl_parameters

1715:
1716: x_ser_num_in_item_id := FALSE;
1717: select serial_number_type
1718: into l_serial_number_type
1719: from mtl_parameters
1720: where organization_id = p_organization_id;
1721:
1722: mtl_serial_check.SNUniqueCheck(
1723: p_api_version => 0.9,

Line 1821: mtl_parameters mp,

1817: mtl_serial_numbers msn,
1818: fa_additions fa,
1819: csi_i_assets cia,
1820: mtl_system_items msi,
1821: mtl_parameters mp,
1822: eam_org_maint_defaults eomd,
1823: mtl_system_items msi_prod,
1824: mtl_serial_numbers msn_prod,
1825: mtl_parameters mp_prod

Line 1825: mtl_parameters mp_prod

1821: mtl_parameters mp,
1822: eam_org_maint_defaults eomd,
1823: mtl_system_items msi_prod,
1824: mtl_serial_numbers msn_prod,
1825: mtl_parameters mp_prod
1826: where cii.last_vld_organization_id = msn.current_organization_id
1827: and cii.inventory_item_id=msn.inventory_item_id
1828: and cii.serial_number=msn.serial_number
1829: and cii.last_vld_organization_id = p_organization_id