VIEW: APPS.XLA_AAD_LINE_DEFN_ASSGNS_F_V

Source

View Text - Preformatted

SELECT xal.rowid row_id , xal.amb_context_code , xal.application_id , xal.event_class_code , xal.event_type_code , xal.product_rule_type_code , xal.product_rule_code , xal.line_definition_code , xal.line_definition_owner_code , xla.name line_definition_name , lk.meaning line_definition_owner , xla.description line_definition_desc , xal.object_version_number object_version_number , xal.creation_date creation_date , xal.created_by created_by , xal.last_update_date last_update_date , xal.last_updated_by last_updated_by , xal.last_update_login last_update_login FROM xla_aad_line_defn_assgns xal , xla_line_definitions_tl xla , xla_lookups lk WHERE lk.lookup_code = xal.line_definition_owner_code AND lk.lookup_type = 'XLA_OWNER_TYPE' AND xla.line_definition_owner_code = xal.line_definition_owner_code AND xla.line_definition_code = xal.line_definition_code AND xla.event_class_code = xal.event_class_code AND xla.event_type_code = xal.event_type_code AND xla.application_id = xal.application_id AND xla.amb_context_code = xal.amb_context_code AND xla.language = USERENV('LANG')

View Text - HTML Formatted

SELECT XAL.ROWID ROW_ID
, XAL.AMB_CONTEXT_CODE
, XAL.APPLICATION_ID
, XAL.EVENT_CLASS_CODE
, XAL.EVENT_TYPE_CODE
, XAL.PRODUCT_RULE_TYPE_CODE
, XAL.PRODUCT_RULE_CODE
, XAL.LINE_DEFINITION_CODE
, XAL.LINE_DEFINITION_OWNER_CODE
, XLA.NAME LINE_DEFINITION_NAME
, LK.MEANING LINE_DEFINITION_OWNER
, XLA.DESCRIPTION LINE_DEFINITION_DESC
, XAL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XAL.CREATION_DATE CREATION_DATE
, XAL.CREATED_BY CREATED_BY
, XAL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XAL.LAST_UPDATED_BY LAST_UPDATED_BY
, XAL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM XLA_AAD_LINE_DEFN_ASSGNS XAL
, XLA_LINE_DEFINITIONS_TL XLA
, XLA_LOOKUPS LK
WHERE LK.LOOKUP_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND LK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND XLA.LINE_DEFINITION_OWNER_CODE = XAL.LINE_DEFINITION_OWNER_CODE
AND XLA.LINE_DEFINITION_CODE = XAL.LINE_DEFINITION_CODE
AND XLA.EVENT_CLASS_CODE = XAL.EVENT_CLASS_CODE
AND XLA.EVENT_TYPE_CODE = XAL.EVENT_TYPE_CODE
AND XLA.APPLICATION_ID = XAL.APPLICATION_ID
AND XLA.AMB_CONTEXT_CODE = XAL.AMB_CONTEXT_CODE
AND XLA.LANGUAGE = USERENV('LANG')