APPS.EAM_ASSETNUMBER_PUB dependencies on MFG_LOOKUPS

Line 141: from mfg_lookups

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

Line 147: from mfg_lookups

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

Line 555: from mfg_lookups

551: end;
552:
553: -- select meaning for capital asset
554: select meaning into l_asset_meaning
555: from mfg_lookups
556: where lookup_type = 'MTL_EAM_ASSET_TYPE'
557: and lookup_code=1;
558:
559: --select meaning for rebuild asset

Line 561: from mfg_lookups

557: and lookup_code=1;
558:
559: --select meaning for rebuild asset
560: select meaning into l_rebuild_meaning
561: from mfg_lookups
562: where lookup_type = 'MTL_EAM_ASSET_TYPE'
563: and lookup_code=3;
564:
565: if (p_instance_id is not null) then