View: XLA_ACCTG_METHODS_FVL

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_ACCTG_METHODS_FVL

View Text

SELECT B.ROWID ROW_ID
, B.ACCOUNTING_METHOD_TYPE_CODE ACCOUNTING_METHOD_TYPE_CODE
, L1.MEANING ACCOUNTING_METHOD_TYPE_DSP
, B.ACCOUNTING_METHOD_CODE ACCOUNTING_METHOD_CODE
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.TRANSACTION_COA_ID TRANSACTION_COA_ID
, B.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, F1.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, F2.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, B.ENABLED_FLAG ENABLED_FLAG
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_ACCTG_METHODS_B B
, XLA_ACCTG_METHODS_TL T
, FND_ID_FLEX_STRUCTURES_V F1
, FND_ID_FLEX_STRUCTURES_V F2
, XLA_LOOKUPS L1
WHERE B.ACCOUNTING_METHOD_CODE = T.ACCOUNTING_METHOD_CODE
AND B.ACCOUNTING_METHOD_TYPE_CODE = T.ACCOUNTING_METHOD_TYPE_CODE
AND T.LANGUAGE = USERENV('LANG')
AND B.ACCOUNTING_METHOD_TYPE_CODE = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND B.TRANSACTION_COA_ID = F1.ID_FLEX_NUM(+)
AND F1.ID_FLEX_CODE(+) = 'GL#'
AND F1.APPLICATION_ID(+) = 101
AND B.ACCOUNTING_COA_ID = F2.ID_FLEX_NUM(+)
AND F2.ID_FLEX_CODE(+) = 'GL#'
AND F2.APPLICATION_ID(+) = 101

Columns