APPS.FA_FASCOSTD_XMLP_PKG dependencies on FA_CATEGORY_BOOKS

Line 768: FA_CATEGORY_BOOKS CB,

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

Line 810: FA_CATEGORY_BOOKS CB,

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

Line 1114: FA_CATEGORY_BOOKS CB,

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

Line 1211: FA_CATEGORY_BOOKS CB,

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

Line 1305: FA_CATEGORY_BOOKS CB,

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

Line 1399: FA_CATEGORY_BOOKS CB,

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

Line 1496: FA_CATEGORY_BOOKS CB,

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

Line 1643: FA_CATEGORY_BOOKS CB,

1639: 'RESERVE', DD.Deprn_Reserve,
1640: 'REVAL RESERVE', DD.Reval_Reserve)
1641: FROM
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

Line 1746: FA_CATEGORY_BOOKS CB,

1742: 'RESERVE', DD.Deprn_Reserve,
1743: 'REVAL RESERVE', DD.Reval_Reserve)
1744: FROM
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

Line 1980: FA_CATEGORY_BOOKS CB,

1976: 'RESERVE', DD.Deprn_Reserve,
1977: 'REVAL RESERVE', DD.Reval_Reserve)
1978: FROM
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

Line 2080: FA_CATEGORY_BOOKS CB,

2076: 'RESERVE', DD.Deprn_Reserve,
2077: 'REVAL RESERVE', DD.Reval_Reserve)
2078: FROM
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

Line 2292: FA_CATEGORY_BOOKS CB,

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

Line 2371: FA_CATEGORY_BOOKS CB,

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