eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.FAFV_TRANS_LINES

Source

View Text - Preformatted


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

View Text - HTML Formatted

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