VIEW: APPS.JA_CN_SYSTEM_BANK_PARAMS_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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