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_AC_HEADERS_V

Source

View Text - Preformatted


SELECT
   xahd.ae_header_id AE_HEADER_ID

-- 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))    H_S_DISTRIBUTION_SOURCE_TYPE
-- 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))    H_S_MISC_CASH_ACTIVITY
-- 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))    H_S_PAYABLES_CUSTOMER_SOURCE
-- 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))    H_S_PROJECT_NUMBER
-- 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))    H_S_RECEIPT_APPLICATION_STATUS
-- 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))    H_S_RECEIVABLE_ACTIVITY
-- 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))    H_S_TRANSACTION_TYPE
-- 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))    H_S_CHECK_ID
FROM xla_ae_header_details     xahd
     ,xla_analytical_dtl_vals xadv
WHERE xadv.analytical_detail_value_id     = xahd.analytical_detail_value_id
GROUP BY xahd.ae_header_id

View Text - HTML Formatted

SELECT XAHD.AE_HEADER_ID AE_HEADER_ID -- 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)) H_S_DISTRIBUTION_SOURCE_TYPE -- 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)) H_S_MISC_CASH_ACTIVITY -- 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)) H_S_PAYABLES_CUSTOMER_SOURCE -- 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)) H_S_PROJECT_NUMBER -- 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)) H_S_RECEIPT_APPLICATION_STATUS -- 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)) H_S_RECEIVABLE_ACTIVITY -- 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)) H_S_TRANSACTION_TYPE -- 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)) H_S_CHECK_ID FROM XLA_AE_HEADER_DETAILS XAHD
, XLA_ANALYTICAL_DTL_VALS XADV WHERE XADV.ANALYTICAL_DETAIL_VALUE_ID = XAHD.ANALYTICAL_DETAIL_VALUE_ID GROUP BY XAHD.AE_HEADER_ID