DBA Data[Home] [Help]

APPS.FA_CUA_ASSET_WB_APIS_PKG dependencies on FA_LIFE_DERIVATION_INFO

Line 549: from fa_life_derivation_info, fa_lookups fl

545: 'CATEGORY-LIFE', FA_CUA_ASSET_WB_APIS_PKG.get_category_name(derived_from_entity_id),
546: 'LEASE', FA_CUA_ASSET_WB_APIS_PKG.get_lease_number(derived_from_entity_id),
547: 'ASSET', FA_CUA_ASSET_WB_APIS_PKG.get_asset_number(derived_from_entity_id),
548: null ), derived_from_entity_id
549: from fa_life_derivation_info, fa_lookups fl
550: where asset_id =x_asset_id
551: and book_type_code = x_book_type_code
552: and transaction_header_id = (select max(transaction_header_id)
553: from fa_life_derivation_info

Line 553: from fa_life_derivation_info

549: from fa_life_derivation_info, fa_lookups fl
550: where asset_id =x_asset_id
551: and book_type_code = x_book_type_code
552: and transaction_header_id = (select max(transaction_header_id)
553: from fa_life_derivation_info
554: where asset_id =x_asset_id
555: and book_type_code = x_book_type_code
556: and transaction_header_id = nvl(x_transaction_id,
557: transaction_header_id))