APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

Line 764: FA_DEPRN_DETAIL_MRC_V DD

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
767: WHERE ASSET_ID = DH.ASSET_ID
768: AND DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID

Line 1120: FA_DEPRN_DETAIL_MRC_V DD,

1116: 'RESERVE', DD.Deprn_Reserve,
1117: 'REVAL RESERVE', DD.Reval_Reserve)
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

Line 1146: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1142: DD.Deprn_Source_Code AND */
1143: -- End bug fix 5076193
1144: DD.Period_Counter =
1145: (SELECT MAX (SUB_DD.Period_Counter)
1146: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1147: WHERE SUB_DD.Book_Type_Code = Book AND
1148: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1149: DH.Distribution_ID = DD.Distribution_ID AND
1150: SUB_DD.Period_Counter <= Period_PC)

Line 1405: FA_DEPRN_DETAIL_MRC_V DD,

1401: 'RESERVE', DD.Deprn_Reserve,
1402: 'REVAL RESERVE', DD.Reval_Reserve)
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

Line 1431: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1427: DD.Deprn_Source_Code AND */
1428: -- end bug fix 5076193
1429: DD.Period_Counter =
1430: (SELECT MAX (SUB_DD.Period_Counter)
1431: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1432: WHERE SUB_DD.Book_Type_Code = Book AND
1433: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1434: DH.Distribution_ID = DD.Distribution_ID AND
1435: SUB_DD.Period_Counter <= Period_PC)

Line 1659: FA_DEPRN_DETAIL_MRC_V DD,

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
1662: fa_GROUP_ASSET_DEFAULT GAD
1663: WHERE

Line 1685: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

1681: 'BEGIN', DD.Deprn_Source_Code, 'D') =
1682: DD.Deprn_Source_Code AND
1683: DD.Period_Counter =
1684: (SELECT MAX (SUB_DD.Period_Counter)
1685: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
1686: WHERE SUB_DD.Book_Type_Code = Book AND
1687: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1688: SUB_DD.Period_Counter <= Period_PC)
1689: AND

Line 1871: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1867: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1868: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1869: AND DD.PERIOD_COUNTER =
1870: (SELECT max (DD_SUB.PERIOD_COUNTER)
1871: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1872: WHERE DD_SUB.BOOK_TYPE_CODE = book
1873: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1874: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
1875: else

Line 2005: FA_DEPRN_DETAIL_MRC_V DD,

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
2008: fa_GROUP_ASSET_DEFAULT GAD
2009: WHERE

Line 2030: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD

2026: 'BEGIN', DD.Deprn_Source_Code, 'D') =
2027: DD.Deprn_Source_Code AND
2028: DD.Period_Counter =
2029: (SELECT MAX (SUB_DD.Period_Counter)
2030: FROM FA_DEPRN_DETAIL_MRC_V SUB_DD
2031: WHERE SUB_DD.Book_Type_Code = Book AND
2032: SUB_DD.Distribution_ID = DH.Distribution_ID AND
2033: SUB_DD.Period_Counter <= Period_PC)
2034: AND

Line 2211: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

2207: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
2208: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
2209: AND DD.PERIOD_COUNTER =
2210: (SELECT max (DD_SUB.PERIOD_COUNTER)
2211: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
2212: WHERE DD_SUB.BOOK_TYPE_CODE = book
2213: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
2214: AND DD_SUB.PERIOD_COUNTER <= PERIOD_PC);
2215: else

Line 2326: FA_DEPRN_DETAIL_MRC_V DD,

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,
2328: FA_ADJUSTMENTS_MRC_V ADJ
2329: WHERE
2330: DH.Book_Type_Code = Distribution_Source_Book