DBA Data[Home] [Help]

APPS.JE_JEHUFAMD_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 271: FA_DISTRIBUTION_HISTORY DH,

267: ,1
268: ,-1) * AJ.ADJUSTMENT_AMOUNT)
269: FROM
270: FA_LOOKUPS RT,
271: FA_DISTRIBUTION_HISTORY DH,
272: FA_TRANSACTION_HEADERS TH,
273: FA_ASSET_HISTORY AH,
274: FA_ADJUSTMENTS AJ,
275: XLA_AE_LINES XAL,

Line 340: FA_DISTRIBUTION_HISTORY DH,

336: CB.DEPRN_RESERVE_ACCT,
337: 'ADDITION',
338: SUM(DD.DEPRN_RESERVE)
339: FROM
340: FA_DISTRIBUTION_HISTORY DH,
341: FA_CATEGORY_BOOKS CB,
342: FA_ADDITIONS AD,
343: FA_DEPRN_DETAIL DD
344: WHERE NOT EXISTS (

Line 402: FA_DISTRIBUTION_HISTORY DH,

398: ,-DD.REVAL_AMORTIZATION))
399: FROM
400: FA_LOOKUPS RT,
401: FA_CATEGORY_BOOKS CB,
402: FA_DISTRIBUTION_HISTORY DH,
403: FA_ASSET_HISTORY AH,
404: FA_DEPRN_DETAIL DD,
405: FA_DEPRN_PERIODS DP
406: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK

Line 584: FA_DISTRIBUTION_HISTORY DH

580: FA_BOOKS BK,
581: FA_CATEGORY_BOOKS CB,
582: FA_ASSET_HISTORY AH,
583: FA_DEPRN_DETAIL DD,
584: FA_DISTRIBUTION_HISTORY DH
585: WHERE DH.BOOK_TYPE_CODE || '' = CP_DISTRIBUTION_SOURCE_BOOK
586: AND DECODE(DD.DEPRN_SOURCE_CODE
587: ,'D'
588: ,CP_PERIOD_POD