DBA Data[Home] [Help]

APPS.FA_FASCOSTD_XMLP_PKG dependencies on FA_ADJUSTMENTS

Line 451: FA_ADJUSTMENTS_MRC_V AJ

447: FA_LOOKUPS RT,
448: FA_DISTRIBUTION_HISTORY DH,
449: FA_TRANSACTION_HEADERS TH,
450: FA_ASSET_HISTORY AH,
451: FA_ADJUSTMENTS_MRC_V AJ
452:
453: /* SLA Changes */
454: ,xla_ae_headers headers
455: ,xla_ae_lines lines

Line 526: FA_ADJUSTMENTS AJ

522: FA_LOOKUPS RT,
523: FA_DISTRIBUTION_HISTORY DH,
524: FA_TRANSACTION_HEADERS TH,
525: FA_ASSET_HISTORY AH,
526: FA_ADJUSTMENTS AJ
527:
528: /* SLA Changes */
529: ,xla_ae_headers headers
530: ,xla_ae_lines lines

Line 606: FA_ADJUSTMENTS_MRC_V AJ

602: FA_LOOKUPS RT,
603: FA_DISTRIBUTION_HISTORY DH,
604: FA_TRANSACTION_HEADERS TH,
605: FA_ASSET_HISTORY AH,
606: FA_ADJUSTMENTS_MRC_V AJ
607:
608: /* SLA Changes */
609: ,xla_ae_headers headers
610: ,xla_ae_lines lines

Line 687: FA_ADJUSTMENTS AJ

683: FA_LOOKUPS RT,
684: FA_DISTRIBUTION_HISTORY DH,
685: FA_TRANSACTION_HEADERS TH,
686: FA_ASSET_HISTORY AH,
687: FA_ADJUSTMENTS AJ
688:
689: /* SLA Changes */
690: ,xla_ae_headers headers
691: ,xla_ae_lines lines

Line 909: FA_ADJUSTMENTS_MRC_V AJ,

905: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
906: AJ.Adjustment_Amount)
907: FROM
908: FA_LOOKUPS RT,
909: FA_ADJUSTMENTS_MRC_V AJ,
910: fa_books_mrc_v bk,
911: fa_group_asset_default gad
912:
913: /* SLA Changes */

Line 980: FA_ADJUSTMENTS AJ,

976: SUM (DECODE (AJ.Debit_Credit_Flag, Balance_Type, 1, -1) *
977: AJ.Adjustment_Amount)
978: FROM
979: FA_LOOKUPS RT,
980: FA_ADJUSTMENTS AJ,
981: fa_books bk,
982: fa_group_asset_default gad
983:
984: /* SLA Changes */

Line 2297: FA_ADJUSTMENTS_MRC_V ADJ

2293: FA_DISTRIBUTION_HISTORY DH,
2294: FA_ASSET_HISTORY AH,
2295: FA_DEPRN_DETAIL_MRC_V DD,
2296: FA_DEPRN_PERIODS_MRC_V DP,
2297: FA_ADJUSTMENTS_MRC_V ADJ
2298: WHERE
2299: DH.Book_Type_Code = Distribution_Source_Book
2300: AND
2301: AH.Asset_ID = DH.Asset_ID AND

Line 2376: FA_ADJUSTMENTS ADJ

2372: FA_DISTRIBUTION_HISTORY DH,
2373: FA_ASSET_HISTORY AH,
2374: FA_DEPRN_DETAIL DD,
2375: FA_DEPRN_PERIODS DP,
2376: FA_ADJUSTMENTS ADJ
2377: WHERE
2378: DH.Book_Type_Code = Distribution_Source_Book
2379: AND
2380: AH.Asset_ID = DH.Asset_ID AND