Skip to content

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

VIEW: JA.JA_CN_ERROR_ACCOUNTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Yes
ACCOUNT_SEGMENT VARCHAR2 (150) Yes
CURRENCY_CODE VARCHAR2 (80) Yes
FUNC_BEGIN_BALANCE NUMBER

ORIG_BEGIN_BALANCE NUMBER

FUNC_PERIOD_NET_DR NUMBER

FUNC_PERIOD_NET_CR NUMBER

ORIG_PERIOD_NET_DR NUMBER

ORIG_PERIOD_NET_CR NUMBER

FUNC_END_BALANCE NUMBER

ORIG_END_BALANCE NUMBER

PERIOD_MON NUMBER
Yes
COST_CENTER VARCHAR2 (100)
THIRD_PARTY_NUMBER VARCHAR2 (300)
PERSONNEL_NUMBER VARCHAR2 (300)
PROJECT_NUMBER VARCHAR2 (100)
HAS_THIRD_PARTY VARCHAR2 (240)
HAS_COST_CENTER VARCHAR2 (240)
HAS_PERSONNEL VARCHAR2 (240)
HAS_PROJECT VARCHAR2 (240)
ACCOUNT_TYPE VARCHAR2 (1)
IS_FOREIGN VARCHAR2 (240)
BALANCE_SIDE VARCHAR2 (240)
ACCOUNT_LEVEL VARCHAR2 (240)
PERIOD_NAME VARCHAR2 (15) Yes
START_DATE DATE
Yes
Query Text

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


SELECT REQUEST_ID
,      ACCOUNT_SEGMENT
,      CURRENCY_CODE
,      FUNC_BEGIN_BALANCE
,      ORIG_BEGIN_BALANCE
,      FUNC_PERIOD_NET_DR
,      FUNC_PERIOD_NET_CR
,      ORIG_PERIOD_NET_DR
,      ORIG_PERIOD_NET_CR
,      FUNC_END_BALANCE
,      ORIG_END_BALANCE
,      PERIOD_MON
,      COST_CENTER
,      THIRD_PARTY_NUMBER
,      PERSONNEL_NUMBER
,      PROJECT_NUMBER
,      HAS_THIRD_PARTY
,      HAS_COST_CENTER
,      HAS_PERSONNEL
,      HAS_PROJECT
,      ACCOUNT_TYPE
,      IS_FOREIGN
,      BALANCE_SIDE
,      ACCOUNT_LEVEL
,      PERIOD_NAME
,      START_DATE
FROM JA.JA_CN_ERROR_ACCOUNTS#;

Dependencies

[top of page]

JA.JA_CN_ERROR_ACCOUNTS# references the following:

SchemaJA
TableJA_CN_ERROR_ACCOUNTS
JA.JA_CN_ERROR_ACCOUNTS# is referenced by following:

SchemaAPPS
SynonymJA_CN_ERROR_ACCOUNTS