APPS.EAM_ASSETNUMBER_PUB dependencies on MFG_LOOKUPS

Line 139: from mfg_lookups

135: end if;
136:
137: -- select meaning for capital asset
138: select meaning into l_asset_meaning
139: from mfg_lookups
140: where lookup_type = 'MTL_EAM_ASSET_TYPE'
141: and lookup_code=1;
142:
143: --select meaning for rebuild asset

Line 145: from mfg_lookups

141: and lookup_code=1;
142:
143: --select meaning for rebuild asset
144: select meaning into l_rebuild_meaning
145: from mfg_lookups
146: where lookup_type = 'MTL_EAM_ASSET_TYPE'
147: and lookup_code=3;
148:
149: -- validate the inventory item

Line 535: from mfg_lookups

531: end;
532:
533: -- select meaning for capital asset
534: select meaning into l_asset_meaning
535: from mfg_lookups
536: where lookup_type = 'MTL_EAM_ASSET_TYPE'
537: and lookup_code=1;
538:
539: --select meaning for rebuild asset

Line 541: from mfg_lookups

537: and lookup_code=1;
538:
539: --select meaning for rebuild asset
540: select meaning into l_rebuild_meaning
541: from mfg_lookups
542: where lookup_type = 'MTL_EAM_ASSET_TYPE'
543: and lookup_code=3;
544:
545: if (p_instance_id is not null) then