eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_JEHUFDAN_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 328: FA_CATEGORY_BOOKS CB,

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 (
332: SELECT

Line 460: FA_CATEGORY_BOOKS CB,

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,
464: FA_LOOKUPS LO,

Line 533: FA_CATEGORY_BOOKS CB,

529: ,'REVAL RESERVE'
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

Line 609: FA_CATEGORY_BOOKS CB,

605: ,'REVAL RESERVE'
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,

Line 700: FA_CATEGORY_BOOKS CB,

696: ,'REVAL RESERVE'
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,

Line 796: FA_CATEGORY_BOOKS CB,

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,
800: FA_LOOKUPS LO,

Line 873: FA_CATEGORY_BOOKS CB,

869: SUM(NVL(DD.DEPRN_ADJUSTMENT_AMOUNT
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,

Line 951: FA_CATEGORY_BOOKS CB,

947: SUM(NVL(DD.DEPRN_ADJUSTMENT_AMOUNT
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,