DBA Data[Home] [Help]

APPS.IPA_ASSET_MECH_APIS_PKG dependencies on FA_LOCATIONS

Line 186: from fa_locations

182: where upper(segment1||segment2||segment3||segment4||segment5||segment6||segment7) = upper(v_asset_category);
183:
184: cursor get_asset_location_id is
185: select location_id
186: from fa_locations
187: where upper(segment1||segment2||segment3||segment4||segment5||segment6||segment7) = upper(v_asset_location);
188:
189: cursor get_book_type IS
190: select bc.book_type_code