DBA Data[Home] [Help] [Dependency Information]

VIEW: JA.JA_CN_SYSTEM_BANK_PARAMS_ALL#

Object Details
Object Name: JA_CN_SYSTEM_BANK_PARAMS_ALL#
Object Type: VIEW
Owner: JA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BANKING_ID NUMBER (15) Yes
LEDGER_ID NUMBER (15) Yes
ACCESS_SET_ID NUMBER (15) Yes
LEGAL_ENTITY_ID NUMBER (15) Yes
COMPANY_NAME VARCHAR2 (100)
ENT_QUALITY VARCHAR2 (30) Yes
ORGANIZATION_ID VARCHAR2 (20) Yes
ENT_INDUSTRY VARCHAR2 (100) Yes
ROUNDING_RULE VARCHAR2 (30)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
CNAO_STAND_VER VARCHAR2 (60)
FLEX_SEGMENT_VALUE VARCHAR2 (50) Yes
FLEX_VALUE_SET_ID NUMBER
Yes
CHART_OF_ACCOUNTS_ID NUMBER

ACCOUNTING_STRUCTURE_FLEX_NUM NUMBER

ACCOUNTING_STRUCTURE_CODE VARCHAR2 (500)
ACCOUNTING_STRUCT_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BANKING_ID
,      LEDGER_ID
,      ACCESS_SET_ID
,      LEGAL_ENTITY_ID
,      COMPANY_NAME
,      ENT_QUALITY
,      ORGANIZATION_ID
,      ENT_INDUSTRY
,      ROUNDING_RULE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CNAO_STAND_VER
,      FLEX_SEGMENT_VALUE
,      FLEX_VALUE_SET_ID
,      CHART_OF_ACCOUNTS_ID
,      ACCOUNTING_STRUCTURE_FLEX_NUM
,      ACCOUNTING_STRUCTURE_CODE
,      ACCOUNTING_STRUCT_ID
FROM JA.JA_CN_SYSTEM_BANK_PARAMS_ALL#;

Dependencies

[top of page]

JA.JA_CN_SYSTEM_BANK_PARAMS_ALL# references the following:

SchemaJA
TableJA_CN_SYSTEM_BANK_PARAMS_ALL
JA.JA_CN_SYSTEM_BANK_PARAMS_ALL# is referenced by following:

SchemaAPPS
SynonymJA_CN_SYSTEM_BANK_PARAMS_ALL