DBA Data[Home] [Help]

APPS.FA_FASRSVED_XMLP_PKG dependencies on FA_ADJUSTMENTS

Line 478: FA_ADJUSTMENTS_MRC_V AJ

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
482: ,xla_ae_lines lines

Line 553: FA_ADJUSTMENTS AJ

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
557: ,xla_ae_lines lines

Line 633: FA_ADJUSTMENTS_MRC_V AJ

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
637: ,xla_ae_lines lines

Line 714: FA_ADJUSTMENTS AJ

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
718: ,xla_ae_lines lines

Line 936: FA_ADJUSTMENTS_MRC_V AJ,

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

Line 1007: FA_ADJUSTMENTS AJ,

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

Line 2324: FA_ADJUSTMENTS_MRC_V ADJ

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
2326: DH.Book_Type_Code = Distribution_Source_Book
2327: AND
2328: AH.Asset_ID = DH.Asset_ID AND

Line 2403: FA_ADJUSTMENTS ADJ

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
2405: DH.Book_Type_Code = Distribution_Source_Book
2406: AND
2407: AH.Asset_ID = DH.Asset_ID AND