VIEW: APPS.XLA_PROD_HEADER_DESC_FVL

Source

View Text - Preformatted

SELECT pah.rowid row_id ,pah.application_id application_id ,pah.amb_context_code amb_context_code ,pah.product_rule_code product_rule_code ,pah.product_rule_type_code product_rule_type_code ,pah.entity_code entity_code ,pah.event_class_code event_class_code ,pah.event_type_code event_type_code ,pah.description_code header_desc_code ,pah.description_type_code header_desc_type_code ,del.name header_desc_name ,lkp.meaning header_desc_type_dsp ,pah.creation_date creation_date ,pah.created_by created_by ,pah.last_update_date last_update_date ,pah.last_update_login last_update_login ,pah.last_updated_by last_updated_by FROM xla_prod_acct_headers pah ,xla_descriptions_tl del ,xla_lookups lkp WHERE pah.application_id = del.application_id (+) AND pah.amb_context_code = del.amb_context_code (+) AND pah.description_type_code = del.description_type_code (+) AND pah.description_code = del.description_code (+) AND del.language (+) = USERENV('LANG') AND pah.description_type_code = lkp.lookup_code(+) AND lkp.lookup_type(+) = 'XLA_OWNER_TYPE'

View Text - HTML Formatted

SELECT PAH.ROWID ROW_ID
, PAH.APPLICATION_ID APPLICATION_ID
, PAH.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, PAH.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, PAH.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, PAH.ENTITY_CODE ENTITY_CODE
, PAH.EVENT_CLASS_CODE EVENT_CLASS_CODE
, PAH.EVENT_TYPE_CODE EVENT_TYPE_CODE
, PAH.DESCRIPTION_CODE HEADER_DESC_CODE
, PAH.DESCRIPTION_TYPE_CODE HEADER_DESC_TYPE_CODE
, DEL.NAME HEADER_DESC_NAME
, LKP.MEANING HEADER_DESC_TYPE_DSP
, PAH.CREATION_DATE CREATION_DATE
, PAH.CREATED_BY CREATED_BY
, PAH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PAH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PAH.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_PROD_ACCT_HEADERS PAH
, XLA_DESCRIPTIONS_TL DEL
, XLA_LOOKUPS LKP
WHERE PAH.APPLICATION_ID = DEL.APPLICATION_ID (+)
AND PAH.AMB_CONTEXT_CODE = DEL.AMB_CONTEXT_CODE (+)
AND PAH.DESCRIPTION_TYPE_CODE = DEL.DESCRIPTION_TYPE_CODE (+)
AND PAH.DESCRIPTION_CODE = DEL.DESCRIPTION_CODE (+)
AND DEL.LANGUAGE (+) = USERENV('LANG')
AND PAH.DESCRIPTION_TYPE_CODE = LKP.LOOKUP_CODE(+)
AND LKP.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE'