VIEW: APPS.XLA_LINE_DEFINITIONS_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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