[Home] [Help]
View: JA_CN_SYSTEM_BANK_PARAMS_ALL_V
View Text
SELECT
JCB.BANKING_ID
,
JCB.LEDGER_ID
,
GLG.NAME LEDGER_NAME
,
JCB.ACCESS_SET_ID
,
JCB.LEGAL_ENTITY_ID
,
XEP.NAME LEGAL_ENTITY
,
COMPANY_NAME
,
ENT_QUALITY
,
ORGANIZATION_ID
,
ENT_INDUSTRY
,
ROUNDING_RULE
,
JCB.CREATED_BY
,
JCB.CREATION_DATE
,
JCB.LAST_UPDATED_BY
,
JCB.LAST_UPDATE_DATE
,
JCB.LAST_UPDATE_LOGIN
,
CNAO_STAND_VER
,
JCB.FLEX_SEGMENT_VALUE
,
JCB.FLEX_VALUE_SET_ID
,
FFV.DESCRIPTION
,
ACCOUNTING_STRUCTURE_FLEX_NUM
,
ACCOUNTING_STRUCTURE_CODE
,
ACCOUNTING_STRUCT_ID
,
JCB.CHART_OF_ACCOUNTS_ID
FROM FND_FLEX_VALUE_SETS FFS
,
FND_FLEX_VALUES_VL FFV
,
JA_CN_SYSTEM_BANK_PARAMS_ALL JCB
,
XLE_ENTITY_PROFILES XEP
,
GL_LEDGERS GLG
WHERE FFS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID
AND FFS.FLEX_VALUE_SET_ID = JCB.FLEX_VALUE_SET_ID
AND XEP.LEGAL_ENTITY_ID=JCB.LEGAL_ENTITY_ID
AND GLG.LEDGER_ID=JCB.LEDGER_ID
AND JCB.FLEX_SEGMENT_VALUE=FFV.FLEX_VALUE