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_DISTRIBUTION_HISTORY

Line 448: FA_DISTRIBUTION_HISTORY DH,

444: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
445: AJ.Adjustment_Amount)
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:

Line 523: FA_DISTRIBUTION_HISTORY DH,

519: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
520: AJ.Adjustment_Amount)
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:

Line 603: FA_DISTRIBUTION_HISTORY DH,

599: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
600: AJ.Adjustment_Amount)
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:

Line 684: FA_DISTRIBUTION_HISTORY DH,

680: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
681: AJ.Adjustment_Amount)
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:

Line 767: FROM FA_DISTRIBUTION_HISTORY DH,

763: null,
764: CB.Deprn_Reserve_Acct,
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

Line 809: FROM FA_DISTRIBUTION_HISTORY DH,

805: null,
806: CB.Deprn_Reserve_Acct,
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

Line 1111: FA_DISTRIBUTION_HISTORY DH,

1107: 'CIP COST', DD.Cost,
1108: 'RESERVE', DD.Deprn_Reserve,
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

Line 1208: FA_DISTRIBUTION_HISTORY DH,

1204: 'CIP COST', DD.Cost,
1205: 'RESERVE', DD.Deprn_Reserve,
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

Line 1302: FA_DISTRIBUTION_HISTORY DH,

1298: 'CIP COST', DD.Cost,
1299: 'RESERVE', DD.Deprn_Reserve,
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

Line 1396: FA_DISTRIBUTION_HISTORY DH,

1392: 'CIP COST', DD.Cost,
1393: 'RESERVE', DD.Deprn_Reserve,
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

Line 1493: FA_DISTRIBUTION_HISTORY DH,

1489: 'CIP COST', DD.Cost,
1490: 'RESERVE', DD.Deprn_Reserve,
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

Line 1646: FA_DISTRIBUTION_HISTORY DH,

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
1649: WHERE
1650: -- Commented by Prabakar

Line 1749: FA_DISTRIBUTION_HISTORY DH,

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
1752: WHERE
1753: -- Commented by Prabakar

Line 1983: FA_DISTRIBUTION_HISTORY DH,

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
1986: WHERE
1987: -- Commented by Prabakar

Line 2083: FA_DISTRIBUTION_HISTORY DH,

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
2086: WHERE
2087: -- Commented by Prabakar

Line 2293: FA_DISTRIBUTION_HISTORY DH,

2289: 'REVAL RESERVE', -DD.Reval_Amortization))
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

Line 2372: FA_DISTRIBUTION_HISTORY DH,

2368: 'REVAL RESERVE', -DD.Reval_Amortization))
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