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_ASSET_HISTORY

Line 468: FA_ASSET_HISTORY AH,

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:
471: /* SLA Changes */
472: ,xla_ae_headers headers

Line 543: FA_ASSET_HISTORY AH,

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:
546: /* SLA Changes */
547: ,xla_ae_headers headers

Line 623: FA_ASSET_HISTORY AH,

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:
626: /* SLA Changes */
627: ,xla_ae_headers headers

Line 704: FA_ASSET_HISTORY AH,

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:
707: /* SLA Changes */
708: ,xla_ae_headers headers

Line 787: FA_ASSET_HISTORY AH,

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
790: FROM FA_BALANCES_REPORT_GT
791: WHERE ASSET_ID = DH.ASSET_ID

Line 829: FA_ASSET_HISTORY AH,

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
832: FROM FA_BALANCES_REPORT_GT
833: WHERE ASSET_ID = DH.ASSET_ID

Line 1145: FA_ASSET_HISTORY AH,

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
1148: WHERE
1149: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1242: FA_ASSET_HISTORY AH,

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
1245: WHERE
1246: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1336: FA_ASSET_HISTORY AH,

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
1339: WHERE
1340: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1430: FA_ASSET_HISTORY AH,

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
1433: WHERE
1434: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1527: FA_ASSET_HISTORY AH,

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
1530: WHERE
1531: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1682: FA_ASSET_HISTORY AH,

1678: 'REVAL RESERVE', DD.Reval_Reserve)
1679: FROM
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

Line 1785: FA_ASSET_HISTORY AH,

1781: 'REVAL RESERVE', DD.Reval_Reserve)
1782: FROM
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

Line 2028: FA_ASSET_HISTORY AH,

2024: 'REVAL RESERVE', DD.Reval_Reserve)
2025: FROM
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

Line 2128: FA_ASSET_HISTORY AH,

2124: 'REVAL RESERVE', DD.Reval_Reserve)
2125: FROM
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

Line 2349: FA_ASSET_HISTORY AH,

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
2353: WHERE

Line 2428: FA_ASSET_HISTORY AH,

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
2432: WHERE