DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_DISTRIBUTION_HISTORY

Line 827: FA_DISTRIBUTION_HISTORY DH,

823: ,
824: DD.COST
825: FROM
826: FA_CATEGORY_BOOKS CB,
827: FA_DISTRIBUTION_HISTORY DH,
828: FA_ASSET_HISTORY AH,
829: FA_DEPRN_DETAIL DD,
830: FA_BOOKS BK, -- Added for Member Track
831: FA_ADJUSTMENTS AJ

Line 942: FA_DISTRIBUTION_HISTORY DH,

938: 'REVAL RESERVE', DD.Reval_Reserve),
939: DD.COST
940: FROM
941: FA_CATEGORY_BOOKS CB,
942: FA_DISTRIBUTION_HISTORY DH,
943: FA_ASSET_HISTORY AH,
944: FA_DEPRN_DETAIL DD,
945: FA_BOOKS BK,
946: FA_DEPRN_PERIODS DP_BROW

Line 1012: FA_DISTRIBUTION_HISTORY DH,

1008: ,
1009: DD.COST
1010: FROM
1011: FA_CATEGORY_BOOKS CB,
1012: FA_DISTRIBUTION_HISTORY DH,
1013: FA_ASSET_HISTORY AH,
1014: FA_MC_DEPRN_DETAIL DD,
1015: FA_MC_BOOKS BK, -- Added for Member Track
1016: FA_MC_ADJUSTMENTS AJ

Line 1132: FA_DISTRIBUTION_HISTORY DH,

1128: 'REVAL RESERVE', DD.Reval_Reserve),
1129: DD.COST
1130: FROM
1131: FA_CATEGORY_BOOKS CB,
1132: FA_DISTRIBUTION_HISTORY DH,
1133: FA_ASSET_HISTORY AH,
1134: FA_MC_DEPRN_DETAIL DD,
1135: FA_MC_BOOKS BK,
1136: FA_MC_DEPRN_PERIODS DP_BROW

Line 1204: FA_DISTRIBUTION_HISTORY DH,

1200: +
1201: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
1202: FROM
1203: FA_CATEGORY_BOOKS CB,
1204: FA_DISTRIBUTION_HISTORY DH,
1205: FA_ASSET_HISTORY AH,
1206: FA_DEPRN_DETAIL DD,
1207: FA_BOOKS BK,
1208: FA_ADJUSTMENTS AJ

Line 1327: FA_DISTRIBUTION_HISTORY DH,

1323: +
1324: nvl( SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) * AJ.Adjustment_Amount),0)
1325: FROM
1326: FA_CATEGORY_BOOKS CB,
1327: FA_DISTRIBUTION_HISTORY DH,
1328: FA_ASSET_HISTORY AH,
1329: FA_MC_DEPRN_DETAIL DD,
1330: FA_MC_BOOKS BK,
1331: FA_MC_ADJUSTMENTS AJ

Line 1449: FA_DISTRIBUTION_HISTORY DH,

1445: AJ.Adjustment_Amount)
1446: FROM
1447: FA_CATEGORY_BOOKS CB,
1448: FA_ASSET_HISTORY AH1,
1449: FA_DISTRIBUTION_HISTORY DH,
1450: FA_TRANSACTION_HEADERS TH,
1451: FA_ASSET_HISTORY AH,
1452: FA_ADJUSTMENTS AJ,
1453: FA_BOOKS BK

Line 1544: FA_DISTRIBUTION_HISTORY DH,

1540: AJ.Adjustment_Amount)
1541: FROM
1542: FA_CATEGORY_BOOKS CB,
1543: FA_ASSET_HISTORY AH1,
1544: FA_DISTRIBUTION_HISTORY DH,
1545: FA_TRANSACTION_HEADERS TH,
1546: FA_ASSET_HISTORY AH,
1547: FA_MC_ADJUSTMENTS AJ,
1548: FA_MC_BOOKS BK

Line 1646: FA_DISTRIBUTION_HISTORY DH,

1642: 'RESERVE', DD.Deprn_Amount,
1643: 'REVAL RESERVE', -DD.Reval_Amortization))
1644: FROM
1645: FA_CATEGORY_BOOKS CB,
1646: FA_DISTRIBUTION_HISTORY DH,
1647: FA_ASSET_HISTORY AH,
1648: FA_DEPRN_DETAIL DD,
1649: FA_DEPRN_PERIODS DP,
1650: FA_BOOKS BK -- Added for Drill Down Report

Line 1718: FA_DISTRIBUTION_HISTORY DH,

1714: 'RESERVE', DD.Deprn_Amount,
1715: 'REVAL RESERVE', -DD.Reval_Amortization))
1716: FROM
1717: FA_CATEGORY_BOOKS CB,
1718: FA_DISTRIBUTION_HISTORY DH,
1719: FA_ASSET_HISTORY AH,
1720: FA_MC_DEPRN_DETAIL DD,
1721: FA_MC_DEPRN_PERIODS DP,
1722: FA_MC_BOOKS BK -- Added for Drill Down Report