DBA Data[Home] [Help]

APPS.FA_FASRSVES_XMLP_PKG dependencies on FA_ADJUSTMENTS

Line 469: FA_ADJUSTMENTS_MRC_V AJ

465: FA_LOOKUPS RT,
466: FA_DISTRIBUTION_HISTORY DH,
467: FA_TRANSACTION_HEADERS TH,
468: FA_ASSET_HISTORY AH,
469: FA_ADJUSTMENTS_MRC_V AJ
470:
471: /* SLA Changes */
472: ,xla_ae_headers headers
473: ,xla_ae_lines lines

Line 544: FA_ADJUSTMENTS AJ

540: FA_LOOKUPS RT,
541: FA_DISTRIBUTION_HISTORY DH,
542: FA_TRANSACTION_HEADERS TH,
543: FA_ASSET_HISTORY AH,
544: FA_ADJUSTMENTS AJ
545:
546: /* SLA Changes */
547: ,xla_ae_headers headers
548: ,xla_ae_lines lines

Line 624: FA_ADJUSTMENTS_MRC_V AJ

620: FA_LOOKUPS RT,
621: FA_DISTRIBUTION_HISTORY DH,
622: FA_TRANSACTION_HEADERS TH,
623: FA_ASSET_HISTORY AH,
624: FA_ADJUSTMENTS_MRC_V AJ
625:
626: /* SLA Changes */
627: ,xla_ae_headers headers
628: ,xla_ae_lines lines

Line 705: FA_ADJUSTMENTS AJ

701: FA_LOOKUPS RT,
702: FA_DISTRIBUTION_HISTORY DH,
703: FA_TRANSACTION_HEADERS TH,
704: FA_ASSET_HISTORY AH,
705: FA_ADJUSTMENTS AJ
706:
707: /* SLA Changes */
708: ,xla_ae_headers headers
709: ,xla_ae_lines lines

Line 933: FA_ADJUSTMENTS_MRC_V AJ,

929: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
930: AJ.Adjustment_Amount)
931: FROM
932: FA_LOOKUPS RT,
933: FA_ADJUSTMENTS_MRC_V AJ,
934: fa_books_mrc_v bk,
935: fa_group_asset_default gad
936:
937: /* SLA Changes */

Line 1004: FA_ADJUSTMENTS AJ,

1000: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
1001: AJ.Adjustment_Amount)
1002: FROM
1003: FA_LOOKUPS RT,
1004: FA_ADJUSTMENTS AJ,
1005: fa_books bk,
1006: fa_group_asset_default gad
1007:
1008: /* SLA Changes */

Line 2352: FA_ADJUSTMENTS_MRC_V ADJ

2348: FA_DISTRIBUTION_HISTORY DH,
2349: FA_ASSET_HISTORY AH,
2350: FA_DEPRN_DETAIL_MRC_V DD,
2351: FA_DEPRN_PERIODS_MRC_V DP,
2352: FA_ADJUSTMENTS_MRC_V ADJ
2353: WHERE
2354: DH.Book_Type_Code = Distribution_Source_Book
2355: AND
2356: AH.Asset_ID = DH.Asset_ID AND

Line 2431: FA_ADJUSTMENTS ADJ

2427: FA_DISTRIBUTION_HISTORY DH,
2428: FA_ASSET_HISTORY AH,
2429: FA_DEPRN_DETAIL DD,
2430: FA_DEPRN_PERIODS DP,
2431: FA_ADJUSTMENTS ADJ
2432: WHERE
2433: DH.Book_Type_Code = Distribution_Source_Book
2434: AND
2435: AH.Asset_ID = DH.Asset_ID AND