VIEW: APPS.XLA_AAD_HEADER_AC_ASSGNS_F_V

Source

View Text - Preformatted

SELECT xah.rowid row_id ,xah.application_id application_id ,xah.amb_context_code amb_context_code ,xah.product_rule_code product_rule_code ,xah.product_rule_type_code product_rule_type_code ,xah.event_class_code event_class_code ,xah.event_type_code event_type_code ,xah.analytical_criterion_code analytical_criterion_code ,xah.analytical_criterion_type_code analytical_criterion_type_code ,xat.name analytical_criterion_name ,xlk.meaning analytical_criterion_type_dsp ,xat.description analytical_criterion_desc ,xab.display_order display_order ,xah.creation_date creation_date ,xah.created_by created_by ,xah.last_update_date last_update_date ,xah.last_update_login last_update_login ,xah.last_updated_by last_updated_by FROM xla_aad_header_ac_assgns xah ,xla_analytical_hdrs_b xab ,xla_analytical_hdrs_tl xat ,xla_lookups xlk WHERE xat.analytical_criterion_type_code = xab.analytical_criterion_type_code AND xat.analytical_criterion_code = xab.analytical_criterion_code AND xat.amb_context_code = xab.amb_context_code AND xat.language = USERENV('LANG') AND xab.amb_context_code = xah.amb_context_code AND xab.analytical_criterion_type_code = xah.analytical_criterion_type_code AND xab.analytical_criterion_code = xah.analytical_criterion_code AND xlk.lookup_code = xab.analytical_criterion_type_code AND xlk.lookup_type = 'XLA_OWNER_TYPE'

View Text - HTML Formatted

SELECT XAH.ROWID ROW_ID
, XAH.APPLICATION_ID APPLICATION_ID
, XAH.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, XAH.PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, XAH.PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, XAH.EVENT_CLASS_CODE EVENT_CLASS_CODE
, XAH.EVENT_TYPE_CODE EVENT_TYPE_CODE
, XAH.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, XAH.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, XAT.NAME ANALYTICAL_CRITERION_NAME
, XLK.MEANING ANALYTICAL_CRITERION_TYPE_DSP
, XAT.DESCRIPTION ANALYTICAL_CRITERION_DESC
, XAB.DISPLAY_ORDER DISPLAY_ORDER
, XAH.CREATION_DATE CREATION_DATE
, XAH.CREATED_BY CREATED_BY
, XAH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XAH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, XAH.LAST_UPDATED_BY LAST_UPDATED_BY
FROM XLA_AAD_HEADER_AC_ASSGNS XAH
, XLA_ANALYTICAL_HDRS_B XAB
, XLA_ANALYTICAL_HDRS_TL XAT
, XLA_LOOKUPS XLK
WHERE XAT.ANALYTICAL_CRITERION_TYPE_CODE = XAB.ANALYTICAL_CRITERION_TYPE_CODE
AND XAT.ANALYTICAL_CRITERION_CODE = XAB.ANALYTICAL_CRITERION_CODE
AND XAT.AMB_CONTEXT_CODE = XAB.AMB_CONTEXT_CODE
AND XAT.LANGUAGE = USERENV('LANG')
AND XAB.AMB_CONTEXT_CODE = XAH.AMB_CONTEXT_CODE
AND XAB.ANALYTICAL_CRITERION_TYPE_CODE = XAH.ANALYTICAL_CRITERION_TYPE_CODE
AND XAB.ANALYTICAL_CRITERION_CODE = XAH.ANALYTICAL_CRITERION_CODE
AND XLK.LOOKUP_CODE = XAB.ANALYTICAL_CRITERION_TYPE_CODE
AND XLK.LOOKUP_TYPE = 'XLA_OWNER_TYPE'