APPS.EAM_ASSET_NUMBER_PVT dependencies on MTL_SYSTEM_ITEMS

Line 197: l_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;

193: l_x_msg_index_out NUMBER;
194: t_output VARCHAR2(2000);
195: t_msg_dummy NUMBER;
196: l_master_organization_id NUMBER;
197: l_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%type;
198: l_internal_party_id NUMBER;
199: l_fa_x_return_status VARCHAR2(2000);
200: l_fa_x_msg_count NUMBER;
201: l_fa_x_msg_data VARCHAR2(2000);

Line 242: from mtl_system_items

238: l_instance_rec.mfg_serial_number_flag := p_mfg_serial_number_flag;
239: l_instance_rec.quantity := 1;
240:
241: select primary_uom_code into l_primary_uom_code
242: from mtl_system_items
243: where organization_id = p_organization_id
244: and inventory_item_id = p_inventory_item_id;
245:
246: l_instance_rec.unit_of_measure := l_primary_uom_code;

Line 1820: mtl_system_items msi,

1816: from csi_item_instances cii,
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,

Line 1823: mtl_system_items msi_prod,

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
1826: where cii.last_vld_organization_id = msn.current_organization_id
1827: and cii.inventory_item_id=msn.inventory_item_id