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.FA_FASRSVES_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 466: FA_DISTRIBUTION_HISTORY DH,

462: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
463: AJ.Adjustment_Amount)
464: FROM
465: FA_LOOKUPS RT,
466: FA_DISTRIBUTION_HISTORY DH,
467: FA_TRANSACTION_HEADERS TH,
468: FA_ASSET_HISTORY AH,
469: FA_ADJUSTMENTS_MRC_V AJ
470:

Line 541: FA_DISTRIBUTION_HISTORY DH,

537: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
538: AJ.Adjustment_Amount)
539: FROM
540: FA_LOOKUPS RT,
541: FA_DISTRIBUTION_HISTORY DH,
542: FA_TRANSACTION_HEADERS TH,
543: FA_ASSET_HISTORY AH,
544: FA_ADJUSTMENTS AJ
545:

Line 621: FA_DISTRIBUTION_HISTORY DH,

617: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
618: AJ.Adjustment_Amount)
619: FROM
620: FA_LOOKUPS RT,
621: FA_DISTRIBUTION_HISTORY DH,
622: FA_TRANSACTION_HEADERS TH,
623: FA_ASSET_HISTORY AH,
624: FA_ADJUSTMENTS_MRC_V AJ
625:

Line 702: FA_DISTRIBUTION_HISTORY DH,

698: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
699: AJ.Adjustment_Amount)
700: FROM
701: FA_LOOKUPS RT,
702: FA_DISTRIBUTION_HISTORY DH,
703: FA_TRANSACTION_HEADERS TH,
704: FA_ASSET_HISTORY AH,
705: FA_ADJUSTMENTS AJ
706:

Line 785: FROM FA_DISTRIBUTION_HISTORY DH,

781: null,
782: CB.Deprn_Reserve_Acct,
783: 'ADDITION',
784: sum(DD.DEPRN_RESERVE)
785: FROM FA_DISTRIBUTION_HISTORY DH,
786: FA_CATEGORY_BOOKS CB,
787: FA_ASSET_HISTORY AH,
788: FA_DEPRN_DETAIL_MRC_V DD
789: WHERE NOT EXISTS (SELECT ASSET_ID

Line 827: FROM FA_DISTRIBUTION_HISTORY DH,

823: null,
824: CB.Deprn_Reserve_Acct,
825: 'ADDITION',
826: sum(DD.DEPRN_RESERVE)
827: FROM FA_DISTRIBUTION_HISTORY DH,
828: FA_CATEGORY_BOOKS CB,
829: FA_ASSET_HISTORY AH,
830: FA_DEPRN_DETAIL DD
831: WHERE NOT EXISTS (SELECT ASSET_ID

Line 1143: FA_DISTRIBUTION_HISTORY DH,

1139: 'CIP COST', DD.Cost,
1140: 'RESERVE', DD.Deprn_Reserve,
1141: 'REVAL RESERVE', DD.Reval_Reserve)
1142: FROM
1143: FA_DISTRIBUTION_HISTORY DH,
1144: FA_DEPRN_DETAIL_MRC_V DD,
1145: FA_ASSET_HISTORY AH,
1146: FA_CATEGORY_BOOKS CB,
1147: FA_BOOKS_MRC_V BK

Line 1240: FA_DISTRIBUTION_HISTORY DH,

1236: 'CIP COST', DD.Cost,
1237: 'RESERVE', DD.Deprn_Reserve,
1238: 'REVAL RESERVE', DD.Reval_Reserve)
1239: FROM
1240: FA_DISTRIBUTION_HISTORY DH,
1241: FA_DEPRN_DETAIL DD,
1242: FA_ASSET_HISTORY AH,
1243: FA_CATEGORY_BOOKS CB,
1244: FA_BOOKS BK

Line 1334: FA_DISTRIBUTION_HISTORY DH,

1330: 'CIP COST', DD.Cost,
1331: 'RESERVE', DD.Deprn_Reserve,
1332: 'REVAL RESERVE', DD.Reval_Reserve)
1333: FROM
1334: FA_DISTRIBUTION_HISTORY DH,
1335: FA_DEPRN_DETAIL DD,
1336: FA_ASSET_HISTORY AH,
1337: FA_CATEGORY_BOOKS CB,
1338: FA_BOOKS BK

Line 1428: FA_DISTRIBUTION_HISTORY DH,

1424: 'CIP COST', DD.Cost,
1425: 'RESERVE', DD.Deprn_Reserve,
1426: 'REVAL RESERVE', DD.Reval_Reserve)
1427: FROM
1428: FA_DISTRIBUTION_HISTORY DH,
1429: FA_DEPRN_DETAIL_MRC_V DD,
1430: FA_ASSET_HISTORY AH,
1431: FA_CATEGORY_BOOKS CB,
1432: FA_BOOKS_MRC_V BK

Line 1525: FA_DISTRIBUTION_HISTORY DH,

1521: 'CIP COST', DD.Cost,
1522: 'RESERVE', DD.Deprn_Reserve,
1523: 'REVAL RESERVE', DD.Reval_Reserve)
1524: FROM
1525: FA_DISTRIBUTION_HISTORY DH,
1526: FA_DEPRN_DETAIL DD,
1527: FA_ASSET_HISTORY AH,
1528: FA_CATEGORY_BOOKS CB,
1529: FA_BOOKS BK

Line 1684: FA_DISTRIBUTION_HISTORY DH,

1680: FA_BOOKS_MRC_V BK,
1681: FA_CATEGORY_BOOKS CB,
1682: FA_ASSET_HISTORY AH,
1683: FA_DEPRN_DETAIL_MRC_V DD,
1684: FA_DISTRIBUTION_HISTORY DH,
1685: -- Commented by Prabakar
1686: fa_GROUP_ASSET_DEFAULT GAD
1687: WHERE
1688: -- Commented by Prabakar

Line 1787: FA_DISTRIBUTION_HISTORY DH,

1783: FA_BOOKS BK,
1784: FA_CATEGORY_BOOKS CB,
1785: FA_ASSET_HISTORY AH,
1786: FA_DEPRN_DETAIL DD,
1787: FA_DISTRIBUTION_HISTORY DH,
1788: -- Commented by Prabakar
1789: fa_GROUP_ASSET_DEFAULT GAD
1790: WHERE
1791: -- Commented by Prabakar

Line 2030: FA_DISTRIBUTION_HISTORY DH,

2026: FA_BOOKS_MRC_V BK,
2027: FA_CATEGORY_BOOKS CB,
2028: FA_ASSET_HISTORY AH,
2029: FA_DEPRN_DETAIL_MRC_V DD,
2030: FA_DISTRIBUTION_HISTORY DH,
2031: -- Commented by Prabakar
2032: fa_GROUP_ASSET_DEFAULT GAD
2033: WHERE
2034: -- Commented by Prabakar

Line 2130: FA_DISTRIBUTION_HISTORY DH,

2126: FA_BOOKS BK,
2127: FA_CATEGORY_BOOKS CB,
2128: FA_ASSET_HISTORY AH,
2129: FA_DEPRN_DETAIL DD,
2130: FA_DISTRIBUTION_HISTORY DH,
2131: -- Commented by Prabakar
2132: fa_GROUP_ASSET_DEFAULT GAD
2133: WHERE
2134: -- Commented by Prabakar

Line 2348: FA_DISTRIBUTION_HISTORY DH,

2344: 'REVAL RESERVE', -DD.Reval_Amortization))
2345: FROM
2346: FA_LOOKUPS_B RT,
2347: FA_CATEGORY_BOOKS CB,
2348: FA_DISTRIBUTION_HISTORY DH,
2349: FA_ASSET_HISTORY AH,
2350: FA_DEPRN_DETAIL_MRC_V DD,
2351: FA_DEPRN_PERIODS_MRC_V DP,
2352: FA_ADJUSTMENTS_MRC_V ADJ

Line 2427: FA_DISTRIBUTION_HISTORY DH,

2423: 'REVAL RESERVE', -DD.Reval_Amortization))
2424: FROM
2425: FA_LOOKUPS_B RT,
2426: FA_CATEGORY_BOOKS CB,
2427: FA_DISTRIBUTION_HISTORY DH,
2428: FA_ASSET_HISTORY AH,
2429: FA_DEPRN_DETAIL DD,
2430: FA_DEPRN_PERIODS DP,
2431: FA_ADJUSTMENTS ADJ