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' |