DBA Data[Home] [Help]

APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_ASSET_HISTORY

Line 444: FA_ASSET_HISTORY AH,

440: FROM
441: FA_LOOKUPS RT,
442: FA_DISTRIBUTION_HISTORY DH,
443: FA_TRANSACTION_HEADERS TH,
444: FA_ASSET_HISTORY AH,
445: FA_ADJUSTMENTS_MRC_V AJ
446:
447: /* SLA Changes */
448: ,xla_ae_headers headers

Line 519: FA_ASSET_HISTORY AH,

515: FROM
516: FA_LOOKUPS RT,
517: FA_DISTRIBUTION_HISTORY DH,
518: FA_TRANSACTION_HEADERS TH,
519: FA_ASSET_HISTORY AH,
520: FA_ADJUSTMENTS AJ
521:
522: /* SLA Changes */
523: ,xla_ae_headers headers

Line 599: FA_ASSET_HISTORY AH,

595: FROM
596: FA_LOOKUPS RT,
597: FA_DISTRIBUTION_HISTORY DH,
598: FA_TRANSACTION_HEADERS TH,
599: FA_ASSET_HISTORY AH,
600: FA_ADJUSTMENTS_MRC_V AJ
601:
602: /* SLA Changes */
603: ,xla_ae_headers headers

Line 680: FA_ASSET_HISTORY AH,

676: FROM
677: FA_LOOKUPS RT,
678: FA_DISTRIBUTION_HISTORY DH,
679: FA_TRANSACTION_HEADERS TH,
680: FA_ASSET_HISTORY AH,
681: FA_ADJUSTMENTS AJ
682:
683: /* SLA Changes */
684: ,xla_ae_headers headers

Line 763: FA_ASSET_HISTORY AH,

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

Line 805: FA_ASSET_HISTORY AH,

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

Line 1121: FA_ASSET_HISTORY AH,

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
1125: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1218: FA_ASSET_HISTORY AH,

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

Line 1312: FA_ASSET_HISTORY AH,

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

Line 1406: FA_ASSET_HISTORY AH,

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
1410: DH.Book_Type_Code = Distribution_Source_Book AND

Line 1503: FA_ASSET_HISTORY AH,

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

Line 1658: FA_ASSET_HISTORY AH,

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

Line 1761: FA_ASSET_HISTORY AH,

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

Line 2004: FA_ASSET_HISTORY AH,

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

Line 2104: FA_ASSET_HISTORY AH,

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

Line 2325: FA_ASSET_HISTORY AH,

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,
2328: FA_ADJUSTMENTS_MRC_V ADJ
2329: WHERE

Line 2404: FA_ASSET_HISTORY AH,

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,
2407: FA_ADJUSTMENTS ADJ
2408: WHERE