DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_DEPRN_DETAIL

Line 496: FA_DEPRN_DETAIL DD,

492: NVL(TH.DATE_EFFECTIVE, ucd),
493: DH.DISTRIBUTION_ID,
494: DD.IMPAIRMENT_RESERVE
495: FROM
496: FA_DEPRN_DETAIL DD,
497: FA_ASSET_HISTORY AH,
498: FA_TRANSACTION_HEADERS TH,
499: FA_TRANSACTION_HEADERS TH_RT,
500: FA_BOOKS BOOKS,

Line 538: FROM FA_DEPRN_DETAIL DD_SUB

534: DD.BOOK_TYPE_CODE = book AND
535: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
536: DD.PERIOD_COUNTER =
537: (SELECT max (DD_SUB.PERIOD_COUNTER)
538: FROM FA_DEPRN_DETAIL DD_SUB
539: WHERE DD_SUB.BOOK_TYPE_CODE = book
540: AND DD_SUB.ASSET_ID = DH.ASSET_ID
541: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
542: AND DD_SUB.PERIOD_COUNTER <= upc)