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.

VIEW: APPS.XLA_ANALYTICAL_CRITERIA_V

Source

View Text - Preformatted


SELECT xald.ae_header_id
      ,xald.ae_line_num
--1: DISTRIBUTION_SOURCE_TYPE, DISTRIBUTION_SOURCE_TYPE
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'SDISTRIBUTION_SOURCE_TYPE',xadv.analytical_detail_char_1))
--2: MISCELLANEOUS_CASH_ACTIVITY, MISC_CASH_ACTIVITY
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'SMISCELLANEOUS_CASH_ACTIVITY',xadv.analytical_detail_char_1))
--3: PAYABLES_CUSTOM_SOURCE, PAYABLES_CUSTOMER_SOURCE
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'SPAYABLES_CUSTOM_SOURCE',xadv.analytical_detail_char_1))
--4: RECEIPT_APPLICATION_STATUS, RECEIPT_APPLICATION_STATUS
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'SRECEIPT_APPLICATION_STATUS',xadv.analytical_detail_char_1))
--5: RECEIVABLE_ACTIVITY, RECEIVABLE_ACTIVITY
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'SRECEIVABLE_ACTIVITY',xadv.analytical_detail_char_1))
--6: TRANSACTION_TYPE, TRANSACTION_TYPE
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'STRANSACTION_TYPE',xadv.analytical_detail_char_1))
--7: PROJECT_NUMBER, PROJECT_NUMBER
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'SPROJECT_NUMBER',xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_char_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_date_1))
--61: CHECK_ID, CHECK_ID
      ,MAX( DECODE( xadv.analytical_criterion_type_code
                     --|| RPAD(xadv.amb_context_code, 30)
                     || xadv.analytical_criterion_code
                   ,'SCHECK_ID',xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
      ,MAX(DECODE( 1, 2, xadv.analytical_detail_number_1))
FROM xla_ae_line_details     xald
     ,xla_analytical_dtl_vals xadv
WHERE xadv.analytical_detail_value_id     = xald.analytical_detail_value_id
GROUP BY xald.ae_header_id
        ,xald.ae_line_num

View Text - HTML Formatted

SELECT XALD.AE_HEADER_ID
, XALD.AE_LINE_NUM --1: DISTRIBUTION_SOURCE_TYPE
, DISTRIBUTION_SOURCE_TYPE
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'SDISTRIBUTION_SOURCE_TYPE'
, XADV.ANALYTICAL_DETAIL_CHAR_1)) --2: MISCELLANEOUS_CASH_ACTIVITY
, MISC_CASH_ACTIVITY
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'SMISCELLANEOUS_CASH_ACTIVITY'
, XADV.ANALYTICAL_DETAIL_CHAR_1)) --3: PAYABLES_CUSTOM_SOURCE
, PAYABLES_CUSTOMER_SOURCE
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'SPAYABLES_CUSTOM_SOURCE'
, XADV.ANALYTICAL_DETAIL_CHAR_1)) --4: RECEIPT_APPLICATION_STATUS
, RECEIPT_APPLICATION_STATUS
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'SRECEIPT_APPLICATION_STATUS'
, XADV.ANALYTICAL_DETAIL_CHAR_1)) --5: RECEIVABLE_ACTIVITY
, RECEIVABLE_ACTIVITY
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'SRECEIVABLE_ACTIVITY'
, XADV.ANALYTICAL_DETAIL_CHAR_1)) --6: TRANSACTION_TYPE
, TRANSACTION_TYPE
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'STRANSACTION_TYPE'
, XADV.ANALYTICAL_DETAIL_CHAR_1)) --7: PROJECT_NUMBER
, PROJECT_NUMBER
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'SPROJECT_NUMBER'
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_CHAR_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_DATE_1)) --61: CHECK_ID
, CHECK_ID
, MAX( DECODE( XADV.ANALYTICAL_CRITERION_TYPE_CODE --|| RPAD(XADV.AMB_CONTEXT_CODE
, 30) || XADV.ANALYTICAL_CRITERION_CODE
, 'SCHECK_ID'
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1))
, MAX(DECODE( 1
, 2
, XADV.ANALYTICAL_DETAIL_NUMBER_1)) FROM XLA_AE_LINE_DETAILS XALD
, XLA_ANALYTICAL_DTL_VALS XADV WHERE XADV.ANALYTICAL_DETAIL_VALUE_ID = XALD.ANALYTICAL_DETAIL_VALUE_ID GROUP BY XALD.AE_HEADER_ID
, XALD.AE_LINE_NUM