DBA Data[Home] [Help]

APPS.FA_RX_SHARED_PKG dependencies on FA_DEPRN_DETAIL

Line 473: FA_DEPRN_DETAIL DD,

469: DD.PERIOD_COUNTER,
470: NVL(TH.DATE_EFFECTIVE, ucd),
471: DH.DISTRIBUTION_ID
472: FROM
473: FA_DEPRN_DETAIL DD,
474: FA_ASSET_HISTORY AH,
475: FA_TRANSACTION_HEADERS TH,
476: FA_TRANSACTION_HEADERS TH_RT,
477: FA_BOOKS BOOKS,

Line 515: FROM FA_DEPRN_DETAIL DD_SUB

511: DD.BOOK_TYPE_CODE = book AND
512: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
513: DD.PERIOD_COUNTER =
514: (SELECT max (DD_SUB.PERIOD_COUNTER)
515: FROM FA_DEPRN_DETAIL DD_SUB
516: WHERE DD_SUB.BOOK_TYPE_CODE = book
517: AND DD_SUB.ASSET_ID = DH.ASSET_ID
518: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
519: AND DD_SUB.PERIOD_COUNTER <= upc)