View: FAFV_TRANS_LINES

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FAFV_TRANS_LINES

View Text

SELECT AJ.ADJUSTMENT_TYPE
, DECODE(AJ.DEBIT_CREDIT_FLAG
, 'DR'
, AJ.ADJUSTMENT_AMOUNT ) DEBIT_AMOUNT
, DECODE(AJ.DEBIT_CREDIT_FLAG
, 'CR'
, AJ.ADJUSTMENT_AMOUNT) CREDIT_AMOUNT
, AJ.TRANSACTION_HEADER_ID
, AJ.SOURCE_TYPE_CODE
, AJ.BOOK_TYPE_CODE
, AJ.ASSET_ID
, AJ.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:GCC' CODE_COMBINATION
, AJ.DISTRIBUTION_ID
, AJ.PERIOD_COUNTER_ADJUSTED
, DP1.PERIOD_NAME PERIOD_ADJUSTED
, AJ.PERIOD_COUNTER_CREATED
, DP2.PERIOD_NAME PERIOD_CREATED
, AJ.LAST_UPDATE_DATE
, AJ.LAST_UPDATED_BY
FROM FA_ADJUSTMENTS AJ
, FA_DEPRN_PERIODS DP1
, FA_DEPRN_PERIODS DP2
, GL_CODE_COMBINATIONS GCC
, XLA_AE_LINES LINES
, XLA_DISTRIBUTION_LINKS LINKS
WHERE AJ.PERIOD_COUNTER_ADJUSTED = DP1.PERIOD_COUNTER
AND AJ.BOOK_TYPE_CODE= DP1.BOOK_TYPE_CODE
AND AJ.PERIOD_COUNTER_CREATED = DP2.PERIOD_COUNTER
AND AJ.BOOK_TYPE_CODE= DP2.BOOK_TYPE_CODE
AND AJ.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND LINKS.SOURCE_DISTRIBUTION_ID_NUM_1 = AJ.TRANSACTION_HEADER_ID
AND LINKS.SOURCE_DISTRIBUTION_ID_NUM_2 = AJ.ADJUSTMENT_LINE_ID
AND LINKS.APPLICATION_ID = 140
AND LINKS.SOURCE_DISTRIBUTION_TYPE = 'TRX'
AND LINES.AE_HEADER_ID = LINKS.AE_HEADER_ID
AND LINES.AE_LINE_NUM = LINKS.AE_LINE_NUM
AND LINES.APPLICATION_ID = 140 WITH READ ONLY

Columns