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_FASRSVED_XMLP_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 475: FA_DISTRIBUTION_HISTORY DH,

471: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
472: AJ.Adjustment_Amount)
473: FROM
474: FA_LOOKUPS RT,
475: FA_DISTRIBUTION_HISTORY DH,
476: FA_TRANSACTION_HEADERS TH,
477: FA_ASSET_HISTORY AH,
478: FA_ADJUSTMENTS_MRC_V AJ
479:

Line 550: FA_DISTRIBUTION_HISTORY DH,

546: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
547: AJ.Adjustment_Amount)
548: FROM
549: FA_LOOKUPS RT,
550: FA_DISTRIBUTION_HISTORY DH,
551: FA_TRANSACTION_HEADERS TH,
552: FA_ASSET_HISTORY AH,
553: FA_ADJUSTMENTS AJ
554:

Line 630: FA_DISTRIBUTION_HISTORY DH,

626: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
627: AJ.Adjustment_Amount)
628: FROM
629: FA_LOOKUPS RT,
630: FA_DISTRIBUTION_HISTORY DH,
631: FA_TRANSACTION_HEADERS TH,
632: FA_ASSET_HISTORY AH,
633: FA_ADJUSTMENTS_MRC_V AJ
634:

Line 711: FA_DISTRIBUTION_HISTORY DH,

707: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
708: AJ.Adjustment_Amount)
709: FROM
710: FA_LOOKUPS RT,
711: FA_DISTRIBUTION_HISTORY DH,
712: FA_TRANSACTION_HEADERS TH,
713: FA_ASSET_HISTORY AH,
714: FA_ADJUSTMENTS AJ
715:

Line 794: FROM FA_DISTRIBUTION_HISTORY DH,

790: null,
791: CB.Deprn_Reserve_Acct,
792: 'ADDITION',
793: sum(DD.DEPRN_RESERVE)
794: FROM FA_DISTRIBUTION_HISTORY DH,
795: FA_CATEGORY_BOOKS CB,
796: FA_ASSET_HISTORY AH,
797: FA_DEPRN_DETAIL_MRC_V DD
798: WHERE NOT EXISTS (SELECT ASSET_ID

Line 836: FROM FA_DISTRIBUTION_HISTORY DH,

832: null,
833: CB.Deprn_Reserve_Acct,
834: 'ADDITION',
835: sum(DD.DEPRN_RESERVE)
836: FROM FA_DISTRIBUTION_HISTORY DH,
837: FA_CATEGORY_BOOKS CB,
838: FA_ASSET_HISTORY AH,
839: FA_DEPRN_DETAIL DD
840: WHERE NOT EXISTS (SELECT ASSET_ID

Line 1138: FA_DISTRIBUTION_HISTORY DH,

1134: 'CIP COST', DD.Cost,
1135: 'RESERVE', DD.Deprn_Reserve,
1136: 'REVAL RESERVE', DD.Reval_Reserve)
1137: FROM
1138: FA_DISTRIBUTION_HISTORY DH,
1139: FA_DEPRN_DETAIL_MRC_V DD,
1140: FA_ASSET_HISTORY AH,
1141: FA_CATEGORY_BOOKS CB,
1142: FA_BOOKS_MRC_V BK

Line 1235: FA_DISTRIBUTION_HISTORY DH,

1231: 'CIP COST', DD.Cost,
1232: 'RESERVE', DD.Deprn_Reserve,
1233: 'REVAL RESERVE', DD.Reval_Reserve)
1234: FROM
1235: FA_DISTRIBUTION_HISTORY DH,
1236: FA_DEPRN_DETAIL DD,
1237: FA_ASSET_HISTORY AH,
1238: FA_CATEGORY_BOOKS CB,
1239: FA_BOOKS BK

Line 1329: FA_DISTRIBUTION_HISTORY DH,

1325: 'CIP COST', DD.Cost,
1326: 'RESERVE', DD.Deprn_Reserve,
1327: 'REVAL RESERVE', DD.Reval_Reserve)
1328: FROM
1329: FA_DISTRIBUTION_HISTORY DH,
1330: FA_DEPRN_DETAIL DD,
1331: FA_ASSET_HISTORY AH,
1332: FA_CATEGORY_BOOKS CB,
1333: FA_BOOKS BK

Line 1423: FA_DISTRIBUTION_HISTORY DH,

1419: 'CIP COST', DD.Cost,
1420: 'RESERVE', DD.Deprn_Reserve,
1421: 'REVAL RESERVE', DD.Reval_Reserve)
1422: FROM
1423: FA_DISTRIBUTION_HISTORY DH,
1424: FA_DEPRN_DETAIL_MRC_V DD,
1425: FA_ASSET_HISTORY AH,
1426: FA_CATEGORY_BOOKS CB,
1427: FA_BOOKS_MRC_V BK

Line 1520: FA_DISTRIBUTION_HISTORY DH,

1516: 'CIP COST', DD.Cost,
1517: 'RESERVE', DD.Deprn_Reserve,
1518: 'REVAL RESERVE', DD.Reval_Reserve)
1519: FROM
1520: FA_DISTRIBUTION_HISTORY DH,
1521: FA_DEPRN_DETAIL DD,
1522: FA_ASSET_HISTORY AH,
1523: FA_CATEGORY_BOOKS CB,
1524: FA_BOOKS BK

Line 1673: FA_DISTRIBUTION_HISTORY DH,

1669: FA_BOOKS_MRC_V BK,
1670: FA_CATEGORY_BOOKS CB,
1671: FA_ASSET_HISTORY AH,
1672: FA_DEPRN_DETAIL_MRC_V DD,
1673: FA_DISTRIBUTION_HISTORY DH,
1674: -- Commented by Prabakar
1675: fa_GROUP_ASSET_DEFAULT GAD
1676: WHERE
1677: -- Commented by Prabakar

Line 1776: FA_DISTRIBUTION_HISTORY DH,

1772: FA_BOOKS BK,
1773: FA_CATEGORY_BOOKS CB,
1774: FA_ASSET_HISTORY AH,
1775: FA_DEPRN_DETAIL DD,
1776: FA_DISTRIBUTION_HISTORY DH,
1777: -- Commented by Prabakar
1778: fa_GROUP_ASSET_DEFAULT GAD
1779: WHERE
1780: -- Commented by Prabakar

Line 2010: FA_DISTRIBUTION_HISTORY DH,

2006: FA_BOOKS_MRC_V BK,
2007: FA_CATEGORY_BOOKS CB,
2008: FA_ASSET_HISTORY AH,
2009: FA_DEPRN_DETAIL_MRC_V DD,
2010: FA_DISTRIBUTION_HISTORY DH,
2011: -- Commented by Prabakar
2012: fa_GROUP_ASSET_DEFAULT GAD
2013: WHERE
2014: -- Commented by Prabakar

Line 2110: FA_DISTRIBUTION_HISTORY DH,

2106: FA_BOOKS BK,
2107: FA_CATEGORY_BOOKS CB,
2108: FA_ASSET_HISTORY AH,
2109: FA_DEPRN_DETAIL DD,
2110: FA_DISTRIBUTION_HISTORY DH,
2111: -- Commented by Prabakar
2112: fa_GROUP_ASSET_DEFAULT GAD
2113: WHERE
2114: -- Commented by Prabakar

Line 2320: FA_DISTRIBUTION_HISTORY DH,

2316: 'REVAL RESERVE', -DD.Reval_Amortization))
2317: FROM
2318: FA_LOOKUPS_B RT,
2319: FA_CATEGORY_BOOKS CB,
2320: FA_DISTRIBUTION_HISTORY DH,
2321: FA_ASSET_HISTORY AH,
2322: FA_DEPRN_DETAIL_MRC_V DD,
2323: FA_DEPRN_PERIODS_MRC_V DP,
2324: FA_ADJUSTMENTS_MRC_V ADJ

Line 2399: FA_DISTRIBUTION_HISTORY DH,

2395: 'REVAL RESERVE', -DD.Reval_Amortization))
2396: FROM
2397: FA_LOOKUPS_B RT,
2398: FA_CATEGORY_BOOKS CB,
2399: FA_DISTRIBUTION_HISTORY DH,
2400: FA_ASSET_HISTORY AH,
2401: FA_DEPRN_DETAIL DD,
2402: FA_DEPRN_PERIODS DP,
2403: FA_ADJUSTMENTS ADJ