1. Tables and Views for Financials
  2. JA_CN_COA_V

JA_CN_COA_V

Details

  • Schema: FUSION

  • Object owner: JA

  • Object type: VIEW

Columns

Name

CHART_OF_ACCOUNT_ID

STRUCTURE_SIN_ID

COA_TITLE

COA_DESC

Query

SQL_Statement

SELECT sib.STRUCTURE_INSTANCE_NUMBER AS CHART_OF_ACCOUNT_ID,

sib.STRUCTURE_INSTANCE_ID AS STRUCTURE_SIN_ID,

sit.NAME AS coa_title,

sit.DESCRIPTION AS coa_desc

FROM fnd_kf_str_instances_b sib,

fnd_kf_str_instances_tl sit

WHERE sib.APPLICATION_ID = '101'

AND sib.KEY_FLEXFIELD_CODE = 'GL#'

AND sib.APPLICATION_ID = sit.APPLICATION_ID

AND sib.KEY_FLEXFIELD_CODE = sit.KEY_FLEXFIELD_CODE

AND sib.STRUCTURE_INSTANCE_CODE = sit.STRUCTURE_INSTANCE_CODE

AND sib.ENABLED_FLAG = 'Y'

AND sit.LANGUAGE = 'US'