DBA Data[Home] [Help]

APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_ASSET_HISTORY

Line 477: FA_ASSET_HISTORY AH,

473: FROM
474: FA_LOOKUPS RT,
475: FA_DISTRIBUTION_HISTORY DH,
476: FA_TRANSACTION_HEADERS TH,
477: FA_ASSET_HISTORY AH,
478: FA_ADJUSTMENTS_MRC_V AJ
479:
480: /* SLA Changes */
481: ,xla_ae_headers headers

Line 552: FA_ASSET_HISTORY AH,

548: FROM
549: FA_LOOKUPS RT,
550: FA_DISTRIBUTION_HISTORY DH,
551: FA_TRANSACTION_HEADERS TH,
552: FA_ASSET_HISTORY AH,
553: FA_ADJUSTMENTS AJ
554:
555: /* SLA Changes */
556: ,xla_ae_headers headers

Line 632: FA_ASSET_HISTORY AH,

628: FROM
629: FA_LOOKUPS RT,
630: FA_DISTRIBUTION_HISTORY DH,
631: FA_TRANSACTION_HEADERS TH,
632: FA_ASSET_HISTORY AH,
633: FA_ADJUSTMENTS_MRC_V AJ
634:
635: /* SLA Changes */
636: ,xla_ae_headers headers

Line 713: FA_ASSET_HISTORY AH,

709: FROM
710: FA_LOOKUPS RT,
711: FA_DISTRIBUTION_HISTORY DH,
712: FA_TRANSACTION_HEADERS TH,
713: FA_ASSET_HISTORY AH,
714: FA_ADJUSTMENTS AJ
715:
716: /* SLA Changes */
717: ,xla_ae_headers headers

Line 796: FA_ASSET_HISTORY AH,

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
800: WHERE ASSET_ID = DH.ASSET_ID

Line 838: FA_ASSET_HISTORY AH,

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
842: WHERE ASSET_ID = DH.ASSET_ID

Line 1140: FA_ASSET_HISTORY AH,

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

Line 1237: FA_ASSET_HISTORY AH,

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

Line 1331: FA_ASSET_HISTORY AH,

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

Line 1425: FA_ASSET_HISTORY AH,

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

Line 1522: FA_ASSET_HISTORY AH,

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

Line 1671: FA_ASSET_HISTORY AH,

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
1675: fa_GROUP_ASSET_DEFAULT GAD

Line 1774: FA_ASSET_HISTORY AH,

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
1778: fa_GROUP_ASSET_DEFAULT GAD

Line 2008: FA_ASSET_HISTORY AH,

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
2012: fa_GROUP_ASSET_DEFAULT GAD

Line 2108: FA_ASSET_HISTORY AH,

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
2112: fa_GROUP_ASSET_DEFAULT GAD

Line 2321: FA_ASSET_HISTORY AH,

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,
2324: FA_ADJUSTMENTS_MRC_V ADJ
2325: WHERE

Line 2400: FA_ASSET_HISTORY AH,

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,
2403: FA_ADJUSTMENTS ADJ
2404: WHERE