View: XLA_LINE_DEFINITIONS_F_V

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

View Text

SELECT XLAB.ROWID ROW_ID
, XLAB.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, FAT.APPLICATION_NAME APPLICATION_NAME
, XLAB.APPLICATION_ID APPLICATION_ID
, XEC.ENTITY_CODE ENTITY_CODE
, XLAB.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XLAB.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XLAB.LINE_DEFINITION_OWNER_CODE LINE_DEFINITION_OWNER_CODE
, XLAB.LINE_DEFINITION_CODE LINE_DEFINITION_CODE
, XEC.NAME EVENT_CLASS_NAME
, XET.NAME EVENT_TYPE_NAME
, LK.MEANING LINE_DEFINITION_OWNER
, XLAT.NAME LINE_DEFINITION_NAME
, XLAT.DESCRIPTION DESCRIPTION
, LK2.MEANING VALIDATION_STATUS
, XLAB.VALIDATION_STATUS_CODE VALIDATION_STATUS_CODE
, XLAB.ENABLED_FLAG ENABLED_FLAG
, FIFST.ID_FLEX_STRUCTURE_NAME TRANSACTION_COA_NAME
, XLAB.TRANSACTION_COA_ID TRANSACTION_COA_ID
, FIFSA.ID_FLEX_STRUCTURE_NAME ACCOUNTING_COA_NAME
, XLAB.ACCOUNTING_COA_ID ACCOUNTING_COA_ID
, XLAB.BUDGETARY_CONTROL_FLAG BUDGETARY_CONTROL_FLAG
, XLAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XLAB.CREATION_DATE CREATION_DATE
, XLAB.CREATED_BY CREATED_BY
, XLAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XLAB.LAST_UPDATED_BY LAST_UPDATED_BY
, XLAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_LINE_DEFINITIONS_B XLAB
, XLA_LINE_DEFINITIONS_TL XLAT
, FND_APPLICATION_TL FAT
, XLA_EVENT_CLASSES_TL XEC
, XLA_EVENT_TYPES_TL XET
, XLA_LOOKUPS LK
, XLA_LOOKUPS LK2
, FND_ID_FLEX_STRUCTURES_V FIFSA
, FND_ID_FLEX_STRUCTURES_V FIFST
WHERE FAT.LANGUAGE = USERENV('LANG')
AND FAT.APPLICATION_ID = XLAB.APPLICATION_ID
AND XEC.LANGUAGE = USERENV('LANG')
AND XEC.EVENT_CLASS_CODE = XLAB.EVENT_CLASS_CODE
AND XEC.APPLICATION_ID = XLAB.APPLICATION_ID
AND XET.LANGUAGE = USERENV('LANG')
AND XET.EVENT_TYPE_CODE = XLAB.EVENT_TYPE_CODE
AND XET.APPLICATION_ID = XLAB.APPLICATION_ID
AND LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND LK.LOOKUP_CODE = XLAB.LINE_DEFINITION_OWNER_CODE
AND LK2.LOOKUP_TYPE = 'XLA_COMPILE_STATUS_TYPE'
AND LK2.LOOKUP_CODE = XLAB.VALIDATION_STATUS_CODE
AND FIFST.ID_FLEX_NUM(+) = XLAB.TRANSACTION_COA_ID
AND FIFST.ID_FLEX_CODE(+) = 'GL#'
AND FIFST.APPLICATION_ID(+) = 101
AND FIFSA.ID_FLEX_NUM(+) = XLAB.ACCOUNTING_COA_ID
AND FIFSA.ID_FLEX_CODE(+) = 'GL#'
AND FIFSA.APPLICATION_ID(+) = 101
AND XLAT.LANGUAGE = USERENV('LANG')
AND XLAT.APPLICATION_ID = XLAB.APPLICATION_ID
AND XLAT.AMB_CONTEXT_CODE = XLAB.AMB_CONTEXT_CODE
AND XLAT.EVENT_CLASS_CODE = XLAB.EVENT_CLASS_CODE
AND XLAT.EVENT_TYPE_CODE = XLAB.EVENT_TYPE_CODE
AND XLAT.LINE_DEFINITION_OWNER_CODE = XLAB.LINE_DEFINITION_OWNER_CODE
AND XLAT.LINE_DEFINITION_CODE = XLAB.LINE_DEFINITION_CODE

Columns