View: XLA_PROD_ACCT_LINES_FVL

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

View Text

SELECT P.ROWID ROW_ID
, P.APPLICATION_ID APPLICATION_ID
, P.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, P.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, P.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, P.ENTITY_CODE ENTITY_CODE
, P.EVENT_CLASS_CODE EVENT_CLASS_CODE
, P.EVENT_TYPE_CODE EVENT_TYPE_CODE
, P.ACCOUNTING_LINE_CODE ACCOUNTING_LINE_CODE
, P.ACCOUNTING_LINE_TYPE_CODE ACCOUNTING_LINE_TYPE_CODE
, L.NAME ACCOUNTING_LINE_NAME
, K.MEANING ACCOUNTING_LINE_TYPE_DSP
, P.DESCRIPTION_CODE DESCRIPTION_CODE
, P.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE
, D.NAME DESCRIPTION_NAME
, K1.MEANING DESCRIPTION_TYPE_DSP
, P.ACTIVE_FLAG ACTIVE_FLAG
, P.CREATION_DATE CREATION_DATE
, P.CREATED_BY CREATED_BY
, P.LAST_UPDATE_DATE LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_PROD_ACCT_LINES P
, XLA_ACCT_LINE_TYPES_TL L
, XLA_DESCRIPTIONS_TL D
, XLA_LOOKUPS K
, XLA_LOOKUPS K1
WHERE P.APPLICATION_ID = L.APPLICATION_ID
AND P.AMB_CONTEXT_CODE = L.AMB_CONTEXT_CODE
AND P.ENTITY_CODE = L.ENTITY_CODE
AND P.EVENT_CLASS_CODE = L.EVENT_CLASS_CODE
AND P.ACCOUNTING_LINE_TYPE_CODE = L.ACCOUNTING_LINE_TYPE_CODE
AND P.ACCOUNTING_LINE_CODE = L.ACCOUNTING_LINE_CODE
AND L.LANGUAGE = USERENV('LANG')
AND P.ACCOUNTING_LINE_TYPE_CODE = K.LOOKUP_CODE
AND K.LOOKUP_TYPE = 'XLA_OWNER_TYPE'
AND P.APPLICATION_ID = D.APPLICATION_ID(+)
AND P.AMB_CONTEXT_CODE = D.AMB_CONTEXT_CODE(+)
AND P.DESCRIPTION_TYPE_CODE = D.DESCRIPTION_TYPE_CODE(+)
AND P.DESCRIPTION_CODE = D.DESCRIPTION_CODE(+)
AND D.LANGUAGE(+) = USERENV('LANG')
AND P.DESCRIPTION_TYPE_CODE = K1.LOOKUP_CODE(+)
AND K1.LOOKUP_TYPE(+) = 'XLA_OWNER_TYPE'

Columns