VIEW: APPS.XLA_PROD_ACCT_LINES_FVL

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'