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_FASCOSTD_XMLP_PKG dependencies on FA_ASSET_HISTORY

Line 450: FA_ASSET_HISTORY AH,

446: FROM
447: FA_LOOKUPS RT,
448: FA_DISTRIBUTION_HISTORY DH,
449: FA_TRANSACTION_HEADERS TH,
450: FA_ASSET_HISTORY AH,
451: FA_ADJUSTMENTS_MRC_V AJ
452:
453: /* SLA Changes */
454: ,xla_ae_headers headers

Line 525: FA_ASSET_HISTORY AH,

521: FROM
522: FA_LOOKUPS RT,
523: FA_DISTRIBUTION_HISTORY DH,
524: FA_TRANSACTION_HEADERS TH,
525: FA_ASSET_HISTORY AH,
526: FA_ADJUSTMENTS AJ
527:
528: /* SLA Changes */
529: ,xla_ae_headers headers

Line 605: FA_ASSET_HISTORY AH,

601: FROM
602: FA_LOOKUPS RT,
603: FA_DISTRIBUTION_HISTORY DH,
604: FA_TRANSACTION_HEADERS TH,
605: FA_ASSET_HISTORY AH,
606: FA_ADJUSTMENTS_MRC_V AJ
607:
608: /* SLA Changes */
609: ,xla_ae_headers headers

Line 686: FA_ASSET_HISTORY AH,

682: FROM
683: FA_LOOKUPS RT,
684: FA_DISTRIBUTION_HISTORY DH,
685: FA_TRANSACTION_HEADERS TH,
686: FA_ASSET_HISTORY AH,
687: FA_ADJUSTMENTS AJ
688:
689: /* SLA Changes */
690: ,xla_ae_headers headers

Line 769: FA_ASSET_HISTORY AH,

765: 'ADDITION',
766: sum(DD.DEPRN_RESERVE)
767: FROM FA_DISTRIBUTION_HISTORY DH,
768: FA_CATEGORY_BOOKS CB,
769: FA_ASSET_HISTORY AH,
770: FA_DEPRN_DETAIL_MRC_V DD
771: WHERE NOT EXISTS (SELECT ASSET_ID
772: FROM FA_BALANCES_REPORT_GT
773: WHERE ASSET_ID = DH.ASSET_ID

Line 811: FA_ASSET_HISTORY AH,

807: 'ADDITION',
808: sum(DD.DEPRN_RESERVE)
809: FROM FA_DISTRIBUTION_HISTORY DH,
810: FA_CATEGORY_BOOKS CB,
811: FA_ASSET_HISTORY AH,
812: FA_DEPRN_DETAIL DD
813: WHERE NOT EXISTS (SELECT ASSET_ID
814: FROM FA_BALANCES_REPORT_GT
815: WHERE ASSET_ID = DH.ASSET_ID

Line 1113: FA_ASSET_HISTORY AH,

1109: 'REVAL RESERVE', DD.Reval_Reserve)
1110: FROM
1111: FA_DISTRIBUTION_HISTORY DH,
1112: FA_DEPRN_DETAIL_MRC_V DD,
1113: FA_ASSET_HISTORY AH,
1114: FA_CATEGORY_BOOKS CB,
1115: FA_BOOKS_MRC_V BK
1116: WHERE
1117: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1210: FA_ASSET_HISTORY AH,

1206: 'REVAL RESERVE', DD.Reval_Reserve)
1207: FROM
1208: FA_DISTRIBUTION_HISTORY DH,
1209: FA_DEPRN_DETAIL DD,
1210: FA_ASSET_HISTORY AH,
1211: FA_CATEGORY_BOOKS CB,
1212: FA_BOOKS BK
1213: WHERE
1214: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1304: FA_ASSET_HISTORY AH,

1300: 'REVAL RESERVE', DD.Reval_Reserve)
1301: FROM
1302: FA_DISTRIBUTION_HISTORY DH,
1303: FA_DEPRN_DETAIL DD,
1304: FA_ASSET_HISTORY AH,
1305: FA_CATEGORY_BOOKS CB,
1306: FA_BOOKS BK
1307: WHERE
1308: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1398: FA_ASSET_HISTORY AH,

1394: 'REVAL RESERVE', DD.Reval_Reserve)
1395: FROM
1396: FA_DISTRIBUTION_HISTORY DH,
1397: FA_DEPRN_DETAIL_MRC_V DD,
1398: FA_ASSET_HISTORY AH,
1399: FA_CATEGORY_BOOKS CB,
1400: FA_BOOKS_MRC_V BK
1401: WHERE
1402: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1495: FA_ASSET_HISTORY AH,

1491: 'REVAL RESERVE', DD.Reval_Reserve)
1492: FROM
1493: FA_DISTRIBUTION_HISTORY DH,
1494: FA_DEPRN_DETAIL DD,
1495: FA_ASSET_HISTORY AH,
1496: FA_CATEGORY_BOOKS CB,
1497: FA_BOOKS BK
1498: WHERE
1499: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1644: FA_ASSET_HISTORY AH,

1640: 'REVAL RESERVE', DD.Reval_Reserve)
1641: FROM
1642: FA_BOOKS_MRC_V BK,
1643: FA_CATEGORY_BOOKS CB,
1644: FA_ASSET_HISTORY AH,
1645: FA_DEPRN_DETAIL_MRC_V DD,
1646: FA_DISTRIBUTION_HISTORY DH,
1647: -- Commented by Prabakar
1648: fa_GROUP_ASSET_DEFAULT GAD

Line 1747: FA_ASSET_HISTORY AH,

1743: 'REVAL RESERVE', DD.Reval_Reserve)
1744: FROM
1745: FA_BOOKS BK,
1746: FA_CATEGORY_BOOKS CB,
1747: FA_ASSET_HISTORY AH,
1748: FA_DEPRN_DETAIL DD,
1749: FA_DISTRIBUTION_HISTORY DH,
1750: -- Commented by Prabakar
1751: fa_GROUP_ASSET_DEFAULT GAD

Line 1981: FA_ASSET_HISTORY AH,

1977: 'REVAL RESERVE', DD.Reval_Reserve)
1978: FROM
1979: FA_BOOKS_MRC_V BK,
1980: FA_CATEGORY_BOOKS CB,
1981: FA_ASSET_HISTORY AH,
1982: FA_DEPRN_DETAIL_MRC_V DD,
1983: FA_DISTRIBUTION_HISTORY DH,
1984: -- Commented by Prabakar
1985: fa_GROUP_ASSET_DEFAULT GAD

Line 2081: FA_ASSET_HISTORY AH,

2077: 'REVAL RESERVE', DD.Reval_Reserve)
2078: FROM
2079: FA_BOOKS BK,
2080: FA_CATEGORY_BOOKS CB,
2081: FA_ASSET_HISTORY AH,
2082: FA_DEPRN_DETAIL DD,
2083: FA_DISTRIBUTION_HISTORY DH,
2084: -- Commented by Prabakar
2085: fa_GROUP_ASSET_DEFAULT GAD

Line 2294: FA_ASSET_HISTORY AH,

2290: FROM
2291: FA_LOOKUPS_B RT,
2292: FA_CATEGORY_BOOKS CB,
2293: FA_DISTRIBUTION_HISTORY DH,
2294: FA_ASSET_HISTORY AH,
2295: FA_DEPRN_DETAIL_MRC_V DD,
2296: FA_DEPRN_PERIODS_MRC_V DP,
2297: FA_ADJUSTMENTS_MRC_V ADJ
2298: WHERE

Line 2373: FA_ASSET_HISTORY AH,

2369: FROM
2370: FA_LOOKUPS_B RT,
2371: FA_CATEGORY_BOOKS CB,
2372: FA_DISTRIBUTION_HISTORY DH,
2373: FA_ASSET_HISTORY AH,
2374: FA_DEPRN_DETAIL DD,
2375: FA_DEPRN_PERIODS DP,
2376: FA_ADJUSTMENTS ADJ
2377: WHERE