eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XLA_AE_LINE_DTL_VALS_V

Product:	XLA - Subledger Accounting
Description:
Implementation/DBA Data:	APPS.XLA_AE_LINE_DTL_VALS_V

View Text

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

Columns

Name
AE_HEADER_ID
AE_LINE_NUM
ANALYTICAL_CRITERION_CODE
ANALYTICAL_CRITERION_TYPE_CODE
AMB_CONTEXT_CODE
ANALYTICAL_DETAIL_VALUE_ID
ANALYTICAL_DETAIL_CHAR_1
ANALYTICAL_DETAIL_CHAR_2
ANALYTICAL_DETAIL_CHAR_3
ANALYTICAL_DETAIL_CHAR_4
ANALYTICAL_DETAIL_CHAR_5
ANALYTICAL_DETAIL_DATE_1
ANALYTICAL_DETAIL_DATE_2
ANALYTICAL_DETAIL_DATE_3
ANALYTICAL_DETAIL_DATE_4
ANALYTICAL_DETAIL_DATE_5
ANALYTICAL_DETAIL_NUMBER_1
ANALYTICAL_DETAIL_NUMBER_2
ANALYTICAL_DETAIL_NUMBER_3
ANALYTICAL_DETAIL_NUMBER_4
ANALYTICAL_DETAIL_NUMBER_5
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN