VIEW: APPS.XLA_AC_LINES_V

Source

View Text - Preformatted

SELECT
   xald.ae_header_id AE_HEADER_ID
  ,xald.ae_line_num  AE_LINE_NUM

-- 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))    L_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))    L_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))    L_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))    L_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))    L_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))    L_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))    L_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))    L_S_CHECK_ID
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 AE_HEADER_ID
, XALD.AE_LINE_NUM AE_LINE_NUM -- 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)) L_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)) L_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)) L_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)) L_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)) L_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)) L_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)) L_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)) L_S_CHECK_ID 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