View: FA_AEL_GL_V

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

View Text

SELECT DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, -1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ACCOUNTED_CR
, DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, 1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ACCOUNTED_DR
, TH.TRANSACTION_DATE_ENTERED ACCOUNTING_DATE
, 'ADJ' AEL_TABLE
, L1.MEANING || ' : ' || TO_NUMBER(TH.TRANSACTION_HEADER_ID) AE_LINE_REFERENCE
, ADJ.ADJUSTMENT_TYPE ACCT_LINE_TYPE
, LUTL.MEANING ACCT_LINE_TYPE_NAME
, 140 APPLICATION_ID
, ADJ.CODE_COMBINATION_ID CODE_COMBINATION_ID
, TH.TRANSACTION_NAME COMMENTS
, SOB.CURRENCY_CODE CURRENCY_CODE
, TO_DATE(NULL) CURRENCY_CONVERSION_DATE
, TO_NUMBER(NULL) CURRENCY_CONVERSION_RATE
, NULL CURRENCY_CONVERSION_TYPE
, NULL CURRENCY_USER_CONVERSION_TYPE
, DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, -1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ENTERED_CR
, DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, 1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ENTERED_DR
, DECODE(ADJ.JE_HEADER_ID
, NULL
, 'N'
, 'Y') GL_TRANSFER_STATUS
, L3.MEANING GL_TRANSFER_STATUS_NAME
, BC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TH.TRANSACTION_HEADER_ID SOURCE_ID
, 'TH' SOURCE_TABLE
, 'TRANSACTION' TRX_CLASS
, 'TRANSACTION' TRX_CLASS_NAME
, TH.TRANSACTION_DATE_ENTERED TRX_DATE
, TH.TRANSACTION_HEADER_ID TRX_HDR_ID
, 'TH' TRX_HDR_TABLE
, TO_CHAR(TH.TRANSACTION_HEADER_ID) TRX_NUMBER_DISPLAYED
, TH.TRANSACTION_HEADER_ID TRX_NUMBER_N
, TH.TRANSACTION_TYPE_CODE TRX_TYPE_C
, L1.MEANING TRX_TYPE_NAME
, ADJ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY LAST_UPDATED_BY
, ADJ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TH.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER ASSET_NUMBER
, AD.DESCRIPTION ASSET_DESCRIPTION
, TH.BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE
, SYS.CATEGORY_FLEX_STRUCTURE ASSET_CATEGORY_FLEX_STRUCTURE
, AH.CATEGORY_ID ASSET_CATEGORY_ID
, SYS.ASSET_KEY_FLEX_STRUCTURE ASSET_KEY_FLEX_STRUCTURE
, AD.ASSET_KEY_CCID ASSET_KEY_CCID
, ADJ.JE_HEADER_ID JE_HEADER_ID
, ADJ.JE_LINE_NUM JE_LINE_NUM
FROM FA_SYSTEM_CONTROLS SYS
, FA_LOOKUPS L3
, FA_LOOKUPS L1
, FA_LOOKUPS_TL LUTL
, GL_SETS_OF_BOOKS SOB
, FA_BOOK_CONTROLS BC
, FA_ASSET_HISTORY AH
, FA_ADDITIONS AD
, FA_ADJUSTMENTS ADJ
, FA_TRANSACTION_HEADERS TH
WHERE L3.LOOKUP_CODE = DECODE(ADJ.JE_HEADER_ID
, NULL
, 'NO'
, 'YES')
AND L3.LOOKUP_TYPE = 'YESNO'
AND L1.LOOKUP_TYPE = 'FAXOLTRX'
AND L1.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE
AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID
AND BC.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE
AND AH.ASSET_ID = AD.ASSET_ID
AND TH.TRANSACTION_HEADER_ID >= AH.TRANSACTION_HEADER_ID_IN
AND TH.TRANSACTION_HEADER_ID < NVL(AH.TRANSACTION_HEADER_ID_OUT
, TH.TRANSACTION_HEADER_ID + 1)
AND ADJ.SOURCE_TYPE_CODE <> 'DEPRECIATION'
AND TH.ASSET_ID = AD.ASSET_ID
AND TH.TRANSACTION_HEADER_ID = ADJ.TRANSACTION_HEADER_ID
AND TH.BOOK_TYPE_CODE = ADJ.BOOK_TYPE_CODE
AND TH.ASSET_ID = ADJ.ASSET_ID
AND LUTL.LOOKUP_CODE= ADJ.ADJUSTMENT_TYPE
AND LUTL.LOOKUP_TYPE='ADJUSTMENT TYPE'
AND LUTL.LANGUAGE =USERENV('LANG') UNION ALL SELECT DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, -1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ACCOUNTED_CR
, DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, 1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ACCOUNTED_DR
, TH.TRANSACTION_DATE_ENTERED ACCOUNTING_DATE
, 'ADJ' AEL_TABLE
, L1.MEANING || ' : ' || TO_NUMBER(TH.TRANSACTION_HEADER_ID) AE_LINE_REFERENCE
, ADJ.ADJUSTMENT_TYPE ACCT_LINE_TYPE
, LUTL.MEANING ACCT_LINE_TYPE_NAME
, 140 APPLICATION_ID
, ADJ.CODE_COMBINATION_ID CODE_COMBINATION_ID
, TH.TRANSACTION_NAME COMMENTS
, SOB.CURRENCY_CODE CURRENCY_CODE
, TO_DATE(NULL) CURRENCY_CONVERSION_DATE
, TO_NUMBER(NULL) CURRENCY_CONVERSION_RATE
, NULL CURRENCY_CONVERSION_TYPE
, NULL CURRENCY_USER_CONVERSION_TYPE
, DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, -1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ENTERED_CR
, DECODE (DECODE (ADJ.DEBIT_CREDIT_FLAG
, 'DR'
, 1
, 'CR'
, -1
, 0) * SIGN (ADJ.ADJUSTMENT_AMOUNT)
, 1
, ABS (ADJ.ADJUSTMENT_AMOUNT)
, NULL) ENTERED_DR
, DECODE(ADJ.JE_HEADER_ID
, NULL
, 'N'
, 'Y') GL_TRANSFER_STATUS
, L3.MEANING GL_TRANSFER_STATUS_NAME
, BC.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, TH.TRANSACTION_HEADER_ID SOURCE_ID
, 'TH' SOURCE_TABLE
, 'TRANSACTION' TRX_CLASS
, 'TRANSACTION' TRX_CLASS_NAME
, TH.TRANSACTION_DATE_ENTERED TRX_DATE
, TH.TRANSACTION_HEADER_ID TRX_HDR_ID
, 'TH' TRX_HDR_TABLE
, TO_CHAR(TH.TRANSACTION_HEADER_ID) TRX_NUMBER_DISPLAYED
, TH.TRANSACTION_HEADER_ID TRX_NUMBER_N
, TH.TRANSACTION_TYPE_CODE TRX_TYPE_C
, L1.MEANING TRX_TYPE_NAME
, ADJ.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ADJ.LAST_UPDATED_BY LAST_UPDATED_BY
, ADJ.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TH.ASSET_ID ASSET_ID
, AD.ASSET_NUMBER ASSET_NUMBER
, AD.DESCRIPTION ASSET_DESCRIPTION
, TH.BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE
, SYS.CATEGORY_FLEX_STRUCTURE ASSET_CATEGORY_FLEX_STRUCTURE
, AH.CATEGORY_ID ASSET_CATEGORY_ID
, SYS.ASSET_KEY_FLEX_STRUCTURE ASSET_KEY_FLEX_STRUCTURE
, AD.ASSET_KEY_CCID ASSET_KEY_CCID
, ADJ.JE_HEADER_ID JE_HEADER_ID
, ADJ.JE_LINE_NUM JE_LINE_NUM
FROM FA_SYSTEM_CONTROLS SYS
, FA_LOOKUPS L3
, FA_LOOKUPS L1
, FA_LOOKUPS_TL LUTL
, GL_SETS_OF_BOOKS SOB
, FA_MC_BOOK_CONTROLS BC
, FA_ASSET_HISTORY AH
, FA_ADDITIONS AD
, FA_MC_ADJUSTMENTS ADJ
, FA_TRANSACTION_HEADERS TH
WHERE L3.LOOKUP_CODE = DECODE(ADJ.JE_HEADER_ID
, NULL
, 'NO'
, 'YES')
AND L3.LOOKUP_TYPE = 'YESNO'
AND L1.LOOKUP_TYPE = 'FAXOLTRX'
AND L1.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE
AND SOB.SET_OF_BOOKS_ID = BC.SET_OF_BOOKS_ID
AND BC.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE
AND AH.ASSET_ID = AD.ASSET_ID
AND TH.TRANSACTION_HEADER_ID >= AH.TRANSACTION_HEADER_ID_IN
AND TH.TRANSACTION_HEADER_ID < NVL(AH.TRANSACTION_HEADER_ID_OUT
, TH.TRANSACTION_HEADER_ID + 1)
AND ADJ.SOURCE_TYPE_CODE <> 'DEPRECIATION'
AND TH.ASSET_ID = AD.ASSET_ID
AND TH.BOOK_TYPE_CODE = ADJ.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = ADJ.SET_OF_BOOKS_ID
AND TH.TRANSACTION_HEADER_ID = ADJ.TRANSACTION_HEADER_ID
AND TH.ASSET_ID = ADJ.ASSET_ID
AND LUTL.LOOKUP_CODE= ADJ.ADJUSTMENT_TYPE
AND LUTL.LOOKUP_TYPE='ADJUSTMENT TYPE'
AND LUTL.LANGUAGE =USERENV('LANG')

Columns