DBA Data[Home] [Help]

APPS.JE_JEHUFDAN_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 275: FA_DISTRIBUTION_HISTORY DH,

271: ,1
272: ,-1) * AJ.ADJUSTMENT_AMOUNT)
273: FROM
274: FA_LOOKUPS RT,
275: FA_DISTRIBUTION_HISTORY DH,
276: FA_TRANSACTION_HEADERS TH,
277: FA_ASSET_HISTORY AH,
278: FA_ADJUSTMENTS AJ
279: WHERE RT.LOOKUP_TYPE = 'REPORT TYPE'

Line 327: FA_DISTRIBUTION_HISTORY DH,

323: CB.DEPRN_RESERVE_ACCT,
324: 'ADDITION',
325: SUM(DD.DEPRN_RESERVE)
326: FROM
327: FA_DISTRIBUTION_HISTORY DH,
328: FA_CATEGORY_BOOKS CB,
329: FA_ADDITIONS AD,
330: FA_DEPRN_DETAIL DD
331: WHERE NOT EXISTS (

Line 384: FA_DISTRIBUTION_HISTORY DH,

380: ,1
381: ,-1) * AJ.ADJUSTMENT_AMOUNT)
382: FROM
383: FA_LOOKUPS RT,
384: FA_DISTRIBUTION_HISTORY DH,
385: FA_TRANSACTION_HEADERS TH,
386: FA_ASSET_HISTORY AH,
387: FA_ADJUSTMENTS AJ,
388: FA_METHODS ME,

Line 459: FA_DISTRIBUTION_HISTORY DH,

455: ,-1
456: ,1) * AJ.ADJUSTMENT_AMOUNT)
457: FROM
458: FA_LOOKUPS RT,
459: FA_DISTRIBUTION_HISTORY DH,
460: FA_CATEGORY_BOOKS CB,
461: FA_TRANSACTION_HEADERS TH,
462: FA_ASSET_HISTORY AH,
463: FA_ADJUSTMENTS AJ,

Line 534: FA_DISTRIBUTION_HISTORY DH,

530: ,-DD.REVAL_AMORTIZATION))
531: FROM
532: FA_LOOKUPS RT,
533: FA_CATEGORY_BOOKS CB,
534: FA_DISTRIBUTION_HISTORY DH,
535: FA_ASSET_HISTORY AH,
536: FA_DEPRN_DETAIL DD,
537: FA_DEPRN_PERIODS DP
538: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK

Line 610: FA_DISTRIBUTION_HISTORY DH,

606: ,-DD.REVAL_AMORTIZATION))
607: FROM
608: FA_LOOKUPS RT,
609: FA_CATEGORY_BOOKS CB,
610: FA_DISTRIBUTION_HISTORY DH,
611: FA_ASSET_HISTORY AH,
612: FA_DEPRN_DETAIL DD,
613: FA_DEPRN_PERIODS DP,
614: FA_DEPRN_PERIODS DP1,

Line 701: FA_DISTRIBUTION_HISTORY DH,

697: ,-DD.REVAL_AMORTIZATION))
698: FROM
699: FA_LOOKUPS RT,
700: FA_CATEGORY_BOOKS CB,
701: FA_DISTRIBUTION_HISTORY DH,
702: FA_ASSET_HISTORY AH,
703: FA_DEPRN_DETAIL DD,
704: FA_DEPRN_PERIODS DP,
705: FA_DEPRN_PERIODS DP1,

Line 795: FA_DISTRIBUTION_HISTORY DH,

791: ,-1
792: ,1) * AJ.ADJUSTMENT_AMOUNT)
793: FROM
794: FA_LOOKUPS RT,
795: FA_DISTRIBUTION_HISTORY DH,
796: FA_CATEGORY_BOOKS CB,
797: FA_TRANSACTION_HEADERS TH,
798: FA_ASSET_HISTORY AH,
799: FA_ADJUSTMENTS AJ,

Line 874: FA_DISTRIBUTION_HISTORY DH,

870: ,0))
871: FROM
872: FA_LOOKUPS RT,
873: FA_CATEGORY_BOOKS CB,
874: FA_DISTRIBUTION_HISTORY DH,
875: FA_ASSET_HISTORY AH,
876: FA_DEPRN_DETAIL DD,
877: FA_DEPRN_PERIODS DP,
878: FA_BOOKS BO,

Line 952: FA_DISTRIBUTION_HISTORY DH,

948: ,0))
949: FROM
950: FA_LOOKUPS RT,
951: FA_CATEGORY_BOOKS CB,
952: FA_DISTRIBUTION_HISTORY DH,
953: FA_ASSET_HISTORY AH,
954: FA_DEPRN_DETAIL DD,
955: FA_DEPRN_PERIODS DP,
956: FA_BOOKS BO,