DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_MC_DEPRN_DETAIL

Line 616: FA_MC_DEPRN_DETAIL DD,

612: NVL(TH.DATE_EFFECTIVE, ucd),
613: DH.DISTRIBUTION_ID,
614: DD.IMPAIRMENT_RESERVE
615: FROM
616: FA_MC_DEPRN_DETAIL DD,
617: FA_ASSET_HISTORY AH,
618: FA_TRANSACTION_HEADERS TH,
619: FA_TRANSACTION_HEADERS TH_RT,
620: FA_MC_BOOKS BOOKS,

Line 660: FROM FA_MC_DEPRN_DETAIL DD_SUB

656: DD.BOOK_TYPE_CODE = book AND
657: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
658: DD.PERIOD_COUNTER =
659: (SELECT max (DD_SUB.PERIOD_COUNTER)
660: FROM FA_MC_DEPRN_DETAIL DD_SUB
661: WHERE DD_SUB.BOOK_TYPE_CODE = book
662: AND DD_SUB.ASSET_ID = DH.ASSET_ID
663: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
664: AND DD_SUB.PERIOD_COUNTER <= upc