APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 762: FA_CATEGORY_BOOKS CB,

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

Line 804: FA_CATEGORY_BOOKS CB,

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

Line 1122: FA_CATEGORY_BOOKS CB,

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

Line 1219: FA_CATEGORY_BOOKS CB,

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

Line 1313: FA_CATEGORY_BOOKS CB,

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

Line 1407: FA_CATEGORY_BOOKS CB,

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

Line 1504: FA_CATEGORY_BOOKS CB,

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

Line 1657: FA_CATEGORY_BOOKS CB,

1653: 'RESERVE', DD.Deprn_Reserve,
1654: 'REVAL RESERVE', DD.Reval_Reserve)
1655: FROM
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

Line 1760: FA_CATEGORY_BOOKS CB,

1756: 'RESERVE', DD.Deprn_Reserve,
1757: 'REVAL RESERVE', DD.Reval_Reserve)
1758: FROM
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

Line 2003: FA_CATEGORY_BOOKS CB,

1999: 'RESERVE', DD.Deprn_Reserve,
2000: 'REVAL RESERVE', DD.Reval_Reserve)
2001: FROM
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

Line 2103: FA_CATEGORY_BOOKS CB,

2099: 'RESERVE', DD.Deprn_Reserve,
2100: 'REVAL RESERVE', DD.Reval_Reserve)
2101: FROM
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

Line 2323: FA_CATEGORY_BOOKS CB,

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

Line 2402: FA_CATEGORY_BOOKS CB,

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