VIEW: APPS.XLA_PROD_ACCT_HEADERS_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 ,ecl.name event_class_name ,etl.name event_type_name ,pah.accounting_required_flag accounting_required_flag ,pah.locking_status_flag locking_status_flag ,pah.validation_status_code validation_status_code ,xlk.meaning validation_status_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_event_classes_tl ecl ,xla_event_types_tl etl ,xla_lookups xlk WHERE pah.application_id = ecl.application_id AND pah.entity_code = ecl.entity_code AND pah.event_class_code = ecl.event_class_code AND ecl.language = USERENV('LANG') AND pah.application_id = etl.application_id AND pah.entity_code = etl.entity_code AND pah.event_class_code = etl.event_class_code AND pah.event_type_code = etl.event_type_code AND etl.language = USERENV('LANG') AND xlk.lookup_code(+) = pah.validation_status_code AND xlk.lookup_type(+) = 'XLA_COMPILE_STATUS_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
, ECL.NAME EVENT_CLASS_NAME
, ETL.NAME EVENT_TYPE_NAME
, PAH.ACCOUNTING_REQUIRED_FLAG ACCOUNTING_REQUIRED_FLAG
, PAH.LOCKING_STATUS_FLAG LOCKING_STATUS_FLAG
, PAH.VALIDATION_STATUS_CODE VALIDATION_STATUS_CODE
, XLK.MEANING VALIDATION_STATUS_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_EVENT_CLASSES_TL ECL
, XLA_EVENT_TYPES_TL ETL
, XLA_LOOKUPS XLK
WHERE PAH.APPLICATION_ID = ECL.APPLICATION_ID
AND PAH.ENTITY_CODE = ECL.ENTITY_CODE
AND PAH.EVENT_CLASS_CODE = ECL.EVENT_CLASS_CODE
AND ECL.LANGUAGE = USERENV('LANG')
AND PAH.APPLICATION_ID = ETL.APPLICATION_ID
AND PAH.ENTITY_CODE = ETL.ENTITY_CODE
AND PAH.EVENT_CLASS_CODE = ETL.EVENT_CLASS_CODE
AND PAH.EVENT_TYPE_CODE = ETL.EVENT_TYPE_CODE
AND ETL.LANGUAGE = USERENV('LANG')
AND XLK.LOOKUP_CODE(+) = PAH.VALIDATION_STATUS_CODE
AND XLK.LOOKUP_TYPE(+) = 'XLA_COMPILE_STATUS_TYPE'