VIEW: APPS.XLA_AE_HDR_DTL_VALS_V

Source

View Text - Preformatted

SELECT hdr.ae_header_id ,val.analytical_criterion_code ,val.analytical_criterion_type_code ,val.amb_context_code ,hdr.analytical_detail_value_id ,val.analytical_detail_char_1 ,val.analytical_detail_char_2 ,val.analytical_detail_char_3 ,val.analytical_detail_char_4 ,val.analytical_detail_char_5 ,val.analytical_detail_date_1 ,val.analytical_detail_date_2 ,val.analytical_detail_date_3 ,val.analytical_detail_date_4 ,val.analytical_detail_date_5 ,val.analytical_detail_number_1 ,val.analytical_detail_number_2 ,val.analytical_detail_number_3 ,val.analytical_detail_number_4 ,val.analytical_detail_number_5 ,val.creation_date ,val.created_by ,val.last_update_date ,val.last_update_login ,val.last_updated_by from xla_ae_header_details hdr ,xla_analytical_dtl_vals val WHERE val.analytical_detail_value_id = hdr.analytical_detail_value_id

View Text - HTML Formatted

SELECT HDR.AE_HEADER_ID
, VAL.ANALYTICAL_CRITERION_CODE
, VAL.ANALYTICAL_CRITERION_TYPE_CODE
, VAL.AMB_CONTEXT_CODE
, HDR.ANALYTICAL_DETAIL_VALUE_ID
, VAL.ANALYTICAL_DETAIL_CHAR_1
, VAL.ANALYTICAL_DETAIL_CHAR_2
, VAL.ANALYTICAL_DETAIL_CHAR_3
, VAL.ANALYTICAL_DETAIL_CHAR_4
, VAL.ANALYTICAL_DETAIL_CHAR_5
, VAL.ANALYTICAL_DETAIL_DATE_1
, VAL.ANALYTICAL_DETAIL_DATE_2
, VAL.ANALYTICAL_DETAIL_DATE_3
, VAL.ANALYTICAL_DETAIL_DATE_4
, VAL.ANALYTICAL_DETAIL_DATE_5
, VAL.ANALYTICAL_DETAIL_NUMBER_1
, VAL.ANALYTICAL_DETAIL_NUMBER_2
, VAL.ANALYTICAL_DETAIL_NUMBER_3
, VAL.ANALYTICAL_DETAIL_NUMBER_4
, VAL.ANALYTICAL_DETAIL_NUMBER_5
, VAL.CREATION_DATE
, VAL.CREATED_BY
, VAL.LAST_UPDATE_DATE
, VAL.LAST_UPDATE_LOGIN
, VAL.LAST_UPDATED_BY
FROM XLA_AE_HEADER_DETAILS HDR
, XLA_ANALYTICAL_DTL_VALS VAL
WHERE VAL.ANALYTICAL_DETAIL_VALUE_ID = HDR.ANALYTICAL_DETAIL_VALUE_ID