APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 795: FA_CATEGORY_BOOKS CB,

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
799: FROM FA_BALANCES_REPORT_GT

Line 837: FA_CATEGORY_BOOKS CB,

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
841: FROM FA_BALANCES_REPORT_GT

Line 1141: FA_CATEGORY_BOOKS CB,

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
1143: WHERE
1144: DH.Book_Type_Code = Distribution_Source_Book AND
1145: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1238: FA_CATEGORY_BOOKS CB,

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
1240: WHERE
1241: DH.Book_Type_Code = Distribution_Source_Book AND
1242: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1332: FA_CATEGORY_BOOKS CB,

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
1334: WHERE
1335: DH.Book_Type_Code = Distribution_Source_Book AND
1336: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1426: FA_CATEGORY_BOOKS CB,

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
1428: WHERE
1429: DH.Book_Type_Code = Distribution_Source_Book AND
1430: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1523: FA_CATEGORY_BOOKS CB,

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
1525: WHERE
1526: DH.Book_Type_Code = Distribution_Source_Book AND
1527: DECODE(DD.Deprn_Source_Code, 'D', P_Date,

Line 1670: FA_CATEGORY_BOOKS CB,

1666: 'RESERVE', DD.Deprn_Reserve,
1667: 'REVAL RESERVE', DD.Reval_Reserve)
1668: FROM
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

Line 1773: FA_CATEGORY_BOOKS CB,

1769: 'RESERVE', DD.Deprn_Reserve,
1770: 'REVAL RESERVE', DD.Reval_Reserve)
1771: FROM
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

Line 2007: FA_CATEGORY_BOOKS CB,

2003: 'RESERVE', DD.Deprn_Reserve,
2004: 'REVAL RESERVE', DD.Reval_Reserve)
2005: FROM
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

Line 2107: FA_CATEGORY_BOOKS CB,

2103: 'RESERVE', DD.Deprn_Reserve,
2104: 'REVAL RESERVE', DD.Reval_Reserve)
2105: FROM
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

Line 2319: FA_CATEGORY_BOOKS CB,

2315: * nvl(ADJ.adjustment_amount,0),
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,

Line 2398: FA_CATEGORY_BOOKS CB,

2394: * nvl(ADJ.adjustment_amount,0),
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,