Product: | XLA - Subledger Accounting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.XLA_AE_HDR_DTL_VALS_V |
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