View: XLA_PROD_ACCT_HEADERS_FVL

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

View Text

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'

Columns