2017年10月16日 星期一

Oracle EBS: 取GL節段設定

SQL:


  SELECT gls.name,
         idfs.id_flex_num chart_of_accounts_id,
         idfs.segment_num,
         idfs.flex_value_set_id,
         fvs.flex_value_set_name,
         idfs.application_id,
         idfs.id_flex_code,
         idfs.application_column_name,
         idfs.segment_name,
         fvs.security_enabled_flag,
         (CASE
             WHEN fvs.validation_type = 'F' THEN 'Table'
             WHEN fvs.validation_type = 'I' THEN 'Independent'
             WHEN fvs.validation_type = 'D' THEN 'Dependent'
             WHEN fvs.validation_type = 'N' THEN 'None'
             WHEN fvs.validation_type = 'P' THEN 'Pair'
             WHEN fvs.validation_type = 'U' THEN 'Special'
             ELSE 'Unknown Type'
          END)
            validation_type,
         (CASE
             WHEN fvs.validation_type = 'F' THEN fvt.application_table_name
             ELSE 'Not Applicable'
          END)
            validation_table_name
    FROM gl_ledgers gls,
         fnd_id_flex_segments idfs,
         fnd_flex_value_sets fvs,
         fnd_flex_validation_tables fvt
   WHERE     gls.chart_of_accounts_id(+) = idfs.id_flex_num
         AND fvs.flex_value_set_id = idfs.flex_value_set_id
         AND gls.ledger_id = ledgerid
         AND idfs.application_id = 101
         AND idfs.id_flex_code IN ('GL#', 'GLLE')
         AND fvs.flex_value_set_id = fvt.flex_value_set_id(+)
ORDER BY idfs.id_flex_code, idfs.id_flex_num, idfs.segment_num ASC;


沒有留言:

張貼留言

注意:只有此網誌的成員可以留言。