VIEW: APPS.XLA_AE_LINE_DTL_VALS_V

Source

View Text - Preformatted

SELECT ln.ae_header_id ,ln.ae_line_num ,val.analytical_criterion_code ,val.analytical_criterion_type_code ,val.amb_context_code ,val.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_updated_by ,val.last_update_login from xla_ae_line_details ln ,xla_analytical_dtl_vals val WHERE val.analytical_detail_value_id = ln.analytical_detail_value_id

View Text - HTML Formatted

SELECT LN.AE_HEADER_ID
, LN.AE_LINE_NUM
, VAL.ANALYTICAL_CRITERION_CODE
, VAL.ANALYTICAL_CRITERION_TYPE_CODE
, VAL.AMB_CONTEXT_CODE
, VAL.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_UPDATED_BY
, VAL.LAST_UPDATE_LOGIN
FROM XLA_AE_LINE_DETAILS LN
, XLA_ANALYTICAL_DTL_VALS VAL
WHERE VAL.ANALYTICAL_DETAIL_VALUE_ID = LN.ANALYTICAL_DETAIL_VALUE_ID