DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on FA_DISTRIBUTION_HISTORY

Line 349: from fa_distribution_history fdh

345: and rownum = 1;
346:
347: select fdh.location_id
348: into l_asset_assignment_tbl(1).fa_location_id
349: from fa_distribution_history fdh
350: where asset_id = P_FA_ASSET_ID
351: and book_type_code = l_asset_assignment_tbl(1).fa_book_type_code
352: and date_ineffective is null
353: and rownum = 1;

Line 667: from fa_distribution_history fdh

663: and rownum = 1;
664:
665: select fdh.location_id
666: into l_asset_assignment_tbl(1).fa_location_id
667: from fa_distribution_history fdh
668: where asset_id = P_FA_ASSET_ID
669: and book_type_code = l_asset_assignment_tbl(1).fa_book_type_code
670: and date_ineffective is null
671: and rownum = 1;

Line 715: from fa_distribution_history fdh

711: and rownum = 1;
712:
713: select fdh.location_id
714: into l_asset_assignment_tbl(1).fa_location_id
715: from fa_distribution_history fdh
716: where asset_id = l_asset_assignment_tbl(1).fa_asset_id
717: and book_type_code = l_asset_assignment_tbl(1).fa_book_type_code
718: and date_ineffective is null
719: and rownum = 1;