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

Line 442: FA_DISTRIBUTION_HISTORY DH,

438: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
439: AJ.Adjustment_Amount)
440: FROM
441: FA_LOOKUPS RT,
442: FA_DISTRIBUTION_HISTORY DH,
443: FA_TRANSACTION_HEADERS TH,
444: FA_ASSET_HISTORY AH,
445: FA_ADJUSTMENTS_MRC_V AJ
446:

Line 517: FA_DISTRIBUTION_HISTORY DH,

513: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
514: AJ.Adjustment_Amount)
515: FROM
516: FA_LOOKUPS RT,
517: FA_DISTRIBUTION_HISTORY DH,
518: FA_TRANSACTION_HEADERS TH,
519: FA_ASSET_HISTORY AH,
520: FA_ADJUSTMENTS AJ
521:

Line 597: FA_DISTRIBUTION_HISTORY DH,

593: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
594: AJ.Adjustment_Amount)
595: FROM
596: FA_LOOKUPS RT,
597: FA_DISTRIBUTION_HISTORY DH,
598: FA_TRANSACTION_HEADERS TH,
599: FA_ASSET_HISTORY AH,
600: FA_ADJUSTMENTS_MRC_V AJ
601:

Line 678: FA_DISTRIBUTION_HISTORY DH,

674: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
675: AJ.Adjustment_Amount)
676: FROM
677: FA_LOOKUPS RT,
678: FA_DISTRIBUTION_HISTORY DH,
679: FA_TRANSACTION_HEADERS TH,
680: FA_ASSET_HISTORY AH,
681: FA_ADJUSTMENTS AJ
682:

Line 761: FROM FA_DISTRIBUTION_HISTORY DH,

757: null,
758: CB.Deprn_Reserve_Acct,
759: 'ADDITION',
760: sum(DD.DEPRN_RESERVE)
761: FROM FA_DISTRIBUTION_HISTORY DH,
762: FA_CATEGORY_BOOKS CB,
763: FA_ASSET_HISTORY AH,
764: FA_DEPRN_DETAIL_MRC_V DD
765: WHERE NOT EXISTS (SELECT ASSET_ID

Line 803: FROM FA_DISTRIBUTION_HISTORY DH,

799: null,
800: CB.Deprn_Reserve_Acct,
801: 'ADDITION',
802: sum(DD.DEPRN_RESERVE)
803: FROM FA_DISTRIBUTION_HISTORY DH,
804: FA_CATEGORY_BOOKS CB,
805: FA_ASSET_HISTORY AH,
806: FA_DEPRN_DETAIL DD
807: WHERE NOT EXISTS (SELECT ASSET_ID

Line 1119: FA_DISTRIBUTION_HISTORY DH,

1115: 'CIP COST', DD.Cost,
1116: 'RESERVE', DD.Deprn_Reserve,
1117: 'REVAL RESERVE', DD.Reval_Reserve)
1118: FROM
1119: FA_DISTRIBUTION_HISTORY DH,
1120: FA_DEPRN_DETAIL_MRC_V DD,
1121: FA_ASSET_HISTORY AH,
1122: FA_CATEGORY_BOOKS CB,
1123: FA_BOOKS_MRC_V BK

Line 1216: FA_DISTRIBUTION_HISTORY DH,

1212: 'CIP COST', DD.Cost,
1213: 'RESERVE', DD.Deprn_Reserve,
1214: 'REVAL RESERVE', DD.Reval_Reserve)
1215: FROM
1216: FA_DISTRIBUTION_HISTORY DH,
1217: FA_DEPRN_DETAIL DD,
1218: FA_ASSET_HISTORY AH,
1219: FA_CATEGORY_BOOKS CB,
1220: FA_BOOKS BK

Line 1310: FA_DISTRIBUTION_HISTORY DH,

1306: 'CIP COST', DD.Cost,
1307: 'RESERVE', DD.Deprn_Reserve,
1308: 'REVAL RESERVE', DD.Reval_Reserve)
1309: FROM
1310: FA_DISTRIBUTION_HISTORY DH,
1311: FA_DEPRN_DETAIL DD,
1312: FA_ASSET_HISTORY AH,
1313: FA_CATEGORY_BOOKS CB,
1314: FA_BOOKS BK

Line 1404: FA_DISTRIBUTION_HISTORY DH,

1400: 'CIP COST', DD.Cost,
1401: 'RESERVE', DD.Deprn_Reserve,
1402: 'REVAL RESERVE', DD.Reval_Reserve)
1403: FROM
1404: FA_DISTRIBUTION_HISTORY DH,
1405: FA_DEPRN_DETAIL_MRC_V DD,
1406: FA_ASSET_HISTORY AH,
1407: FA_CATEGORY_BOOKS CB,
1408: FA_BOOKS_MRC_V BK

Line 1501: FA_DISTRIBUTION_HISTORY DH,

1497: 'CIP COST', DD.Cost,
1498: 'RESERVE', DD.Deprn_Reserve,
1499: 'REVAL RESERVE', DD.Reval_Reserve)
1500: FROM
1501: FA_DISTRIBUTION_HISTORY DH,
1502: FA_DEPRN_DETAIL DD,
1503: FA_ASSET_HISTORY AH,
1504: FA_CATEGORY_BOOKS CB,
1505: FA_BOOKS BK

Line 1660: FA_DISTRIBUTION_HISTORY DH,

1656: FA_BOOKS_MRC_V BK,
1657: FA_CATEGORY_BOOKS CB,
1658: FA_ASSET_HISTORY AH,
1659: FA_DEPRN_DETAIL_MRC_V DD,
1660: FA_DISTRIBUTION_HISTORY DH,
1661: -- Commented by Prabakar
1662: fa_GROUP_ASSET_DEFAULT GAD
1663: WHERE
1664: -- Commented by Prabakar

Line 1763: FA_DISTRIBUTION_HISTORY DH,

1759: FA_BOOKS BK,
1760: FA_CATEGORY_BOOKS CB,
1761: FA_ASSET_HISTORY AH,
1762: FA_DEPRN_DETAIL DD,
1763: FA_DISTRIBUTION_HISTORY DH,
1764: -- Commented by Prabakar
1765: fa_GROUP_ASSET_DEFAULT GAD
1766: WHERE
1767: -- Commented by Prabakar

Line 2006: FA_DISTRIBUTION_HISTORY DH,

2002: FA_BOOKS_MRC_V BK,
2003: FA_CATEGORY_BOOKS CB,
2004: FA_ASSET_HISTORY AH,
2005: FA_DEPRN_DETAIL_MRC_V DD,
2006: FA_DISTRIBUTION_HISTORY DH,
2007: -- Commented by Prabakar
2008: fa_GROUP_ASSET_DEFAULT GAD
2009: WHERE
2010: -- Commented by Prabakar

Line 2106: FA_DISTRIBUTION_HISTORY DH,

2102: FA_BOOKS BK,
2103: FA_CATEGORY_BOOKS CB,
2104: FA_ASSET_HISTORY AH,
2105: FA_DEPRN_DETAIL DD,
2106: FA_DISTRIBUTION_HISTORY DH,
2107: -- Commented by Prabakar
2108: fa_GROUP_ASSET_DEFAULT GAD
2109: WHERE
2110: -- Commented by Prabakar

Line 2324: FA_DISTRIBUTION_HISTORY DH,

2320: 'REVAL RESERVE', -DD.Reval_Amortization))
2321: FROM
2322: FA_LOOKUPS_B RT,
2323: FA_CATEGORY_BOOKS CB,
2324: FA_DISTRIBUTION_HISTORY DH,
2325: FA_ASSET_HISTORY AH,
2326: FA_DEPRN_DETAIL_MRC_V DD,
2327: FA_DEPRN_PERIODS_MRC_V DP,
2328: FA_ADJUSTMENTS_MRC_V ADJ

Line 2403: FA_DISTRIBUTION_HISTORY DH,

2399: 'REVAL RESERVE', -DD.Reval_Amortization))
2400: FROM
2401: FA_LOOKUPS_B RT,
2402: FA_CATEGORY_BOOKS CB,
2403: FA_DISTRIBUTION_HISTORY DH,
2404: FA_ASSET_HISTORY AH,
2405: FA_DEPRN_DETAIL DD,
2406: FA_DEPRN_PERIODS DP,
2407: FA_ADJUSTMENTS ADJ