APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 786: FA_CATEGORY_BOOKS CB,

782: CB.Deprn_Reserve_Acct,
783: 'ADDITION',
784: sum(DD.DEPRN_RESERVE)
785: FROM FA_DISTRIBUTION_HISTORY DH,
786: FA_CATEGORY_BOOKS CB,
787: FA_ASSET_HISTORY AH,
788: FA_DEPRN_DETAIL_MRC_V DD
789: WHERE NOT EXISTS (SELECT ASSET_ID
790: FROM FA_BALANCES_REPORT_GT

Line 828: FA_CATEGORY_BOOKS CB,

824: CB.Deprn_Reserve_Acct,
825: 'ADDITION',
826: sum(DD.DEPRN_RESERVE)
827: FROM FA_DISTRIBUTION_HISTORY DH,
828: FA_CATEGORY_BOOKS CB,
829: FA_ASSET_HISTORY AH,
830: FA_DEPRN_DETAIL DD
831: WHERE NOT EXISTS (SELECT ASSET_ID
832: FROM FA_BALANCES_REPORT_GT

Line 1146: FA_CATEGORY_BOOKS CB,

1142: FROM
1143: FA_DISTRIBUTION_HISTORY DH,
1144: FA_DEPRN_DETAIL_MRC_V DD,
1145: FA_ASSET_HISTORY AH,
1146: FA_CATEGORY_BOOKS CB,
1147: FA_BOOKS_MRC_V BK
1148: WHERE
1149: DH.Book_Type_Code = Distribution_Source_Book AND
1150: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1243: FA_CATEGORY_BOOKS CB,

1239: FROM
1240: FA_DISTRIBUTION_HISTORY DH,
1241: FA_DEPRN_DETAIL DD,
1242: FA_ASSET_HISTORY AH,
1243: FA_CATEGORY_BOOKS CB,
1244: FA_BOOKS BK
1245: WHERE
1246: DH.Book_Type_Code = Distribution_Source_Book AND
1247: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1337: FA_CATEGORY_BOOKS CB,

1333: FROM
1334: FA_DISTRIBUTION_HISTORY DH,
1335: FA_DEPRN_DETAIL DD,
1336: FA_ASSET_HISTORY AH,
1337: FA_CATEGORY_BOOKS CB,
1338: FA_BOOKS BK
1339: WHERE
1340: DH.Book_Type_Code = Distribution_Source_Book AND
1341: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1431: FA_CATEGORY_BOOKS CB,

1427: FROM
1428: FA_DISTRIBUTION_HISTORY DH,
1429: FA_DEPRN_DETAIL_MRC_V DD,
1430: FA_ASSET_HISTORY AH,
1431: FA_CATEGORY_BOOKS CB,
1432: FA_BOOKS_MRC_V BK
1433: WHERE
1434: DH.Book_Type_Code = Distribution_Source_Book AND
1435: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1528: FA_CATEGORY_BOOKS CB,

1524: FROM
1525: FA_DISTRIBUTION_HISTORY DH,
1526: FA_DEPRN_DETAIL DD,
1527: FA_ASSET_HISTORY AH,
1528: FA_CATEGORY_BOOKS CB,
1529: FA_BOOKS BK
1530: WHERE
1531: DH.Book_Type_Code = Distribution_Source_Book AND
1532: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1681: FA_CATEGORY_BOOKS CB,

1677: 'RESERVE', DD.Deprn_Reserve,
1678: 'REVAL RESERVE', DD.Reval_Reserve)
1679: FROM
1680: FA_BOOKS_MRC_V BK,
1681: FA_CATEGORY_BOOKS CB,
1682: FA_ASSET_HISTORY AH,
1683: FA_DEPRN_DETAIL_MRC_V DD,
1684: FA_DISTRIBUTION_HISTORY DH,
1685: -- Commented by Prabakar

Line 1784: FA_CATEGORY_BOOKS CB,

1780: 'RESERVE', DD.Deprn_Reserve,
1781: 'REVAL RESERVE', DD.Reval_Reserve)
1782: FROM
1783: FA_BOOKS BK,
1784: FA_CATEGORY_BOOKS CB,
1785: FA_ASSET_HISTORY AH,
1786: FA_DEPRN_DETAIL DD,
1787: FA_DISTRIBUTION_HISTORY DH,
1788: -- Commented by Prabakar

Line 2027: FA_CATEGORY_BOOKS CB,

2023: 'RESERVE', DD.Deprn_Reserve,
2024: 'REVAL RESERVE', DD.Reval_Reserve)
2025: FROM
2026: FA_BOOKS_MRC_V BK,
2027: FA_CATEGORY_BOOKS CB,
2028: FA_ASSET_HISTORY AH,
2029: FA_DEPRN_DETAIL_MRC_V DD,
2030: FA_DISTRIBUTION_HISTORY DH,
2031: -- Commented by Prabakar

Line 2127: FA_CATEGORY_BOOKS CB,

2123: 'RESERVE', DD.Deprn_Reserve,
2124: 'REVAL RESERVE', DD.Reval_Reserve)
2125: FROM
2126: FA_BOOKS BK,
2127: FA_CATEGORY_BOOKS CB,
2128: FA_ASSET_HISTORY AH,
2129: FA_DEPRN_DETAIL DD,
2130: FA_DISTRIBUTION_HISTORY DH,
2131: -- Commented by Prabakar

Line 2347: FA_CATEGORY_BOOKS CB,

2343: * nvl(ADJ.adjustment_amount,0),
2344: 'REVAL RESERVE', -DD.Reval_Amortization))
2345: FROM
2346: FA_LOOKUPS_B RT,
2347: FA_CATEGORY_BOOKS CB,
2348: FA_DISTRIBUTION_HISTORY DH,
2349: FA_ASSET_HISTORY AH,
2350: FA_DEPRN_DETAIL_MRC_V DD,
2351: FA_DEPRN_PERIODS_MRC_V DP,

Line 2426: FA_CATEGORY_BOOKS CB,

2422: * nvl(ADJ.adjustment_amount,0),
2423: 'REVAL RESERVE', -DD.Reval_Amortization))
2424: FROM
2425: FA_LOOKUPS_B RT,
2426: FA_CATEGORY_BOOKS CB,
2427: FA_DISTRIBUTION_HISTORY DH,
2428: FA_ASSET_HISTORY AH,
2429: FA_DEPRN_DETAIL DD,
2430: FA_DEPRN_PERIODS DP,