DBA Data[Home] [Help]

VIEW: APPS.XLA_ANALYTICAL_ASSGNS_FVL

Source

View Text - Preformatted

SELECT p.rowid row_id ,p.analytical_assignment_id analytical_assignment_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 ,p.analytical_criterion_code analytical_criterion_code ,l.name analytical_criteria_name ,l.description analytical_criteria_desc ,l.display_order display_order ,p.analytical_criterion_type_code analytical_criterion_type_code ,k.meaning analytical_criteria_type_dsp ,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_analytical_assgns p ,xla_analytical_hdrs_vl l ,xla_lookups k WHERE p.analytical_criterion_type_code = l.analytical_criterion_type_code AND p.analytical_criterion_code = l.analytical_criterion_code AND p.amb_context_code = l.amb_context_code AND p.analytical_criterion_type_code = k.lookup_code AND k.lookup_type = 'XLA_OWNER_TYPE'
View Text - HTML Formatted

SELECT P.ROWID ROW_ID
, P.ANALYTICAL_ASSIGNMENT_ID ANALYTICAL_ASSIGNMENT_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
, P.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, L.NAME ANALYTICAL_CRITERIA_NAME
, L.DESCRIPTION ANALYTICAL_CRITERIA_DESC
, L.DISPLAY_ORDER DISPLAY_ORDER
, P.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, K.MEANING ANALYTICAL_CRITERIA_TYPE_DSP
, 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_ANALYTICAL_ASSGNS P
, XLA_ANALYTICAL_HDRS_VL L
, XLA_LOOKUPS K
WHERE P.ANALYTICAL_CRITERION_TYPE_CODE = L.ANALYTICAL_CRITERION_TYPE_CODE
AND P.ANALYTICAL_CRITERION_CODE = L.ANALYTICAL_CRITERION_CODE
AND P.AMB_CONTEXT_CODE = L.AMB_CONTEXT_CODE
AND P.ANALYTICAL_CRITERION_TYPE_CODE = K.LOOKUP_CODE
AND K.LOOKUP_TYPE = 'XLA_OWNER_TYPE'