DBA Data[Home] [Help]

APPS.FA_FASCOSTS_XMLP_PKG dependencies on FA_ADJUSTMENTS

Line 445: FA_ADJUSTMENTS_MRC_V AJ

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

Line 520: FA_ADJUSTMENTS AJ

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

Line 600: FA_ADJUSTMENTS_MRC_V AJ

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

Line 681: FA_ADJUSTMENTS AJ

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

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
2330: DH.Book_Type_Code = Distribution_Source_Book
2331: AND
2332: AH.Asset_ID = DH.Asset_ID AND

Line 2407: FA_ADJUSTMENTS ADJ

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
2409: DH.Book_Type_Code = Distribution_Source_Book
2410: AND
2411: AH.Asset_ID = DH.Asset_ID AND