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

VIEW: AX.AX_DOCUMENT_STATUSES#

Object Details
Object Name: AX_DOCUMENT_STATUSES#
Object Type: VIEW
Owner: AX
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
APPLICATION_ID NUMBER (15) Yes
SET_OF_BOOKS_ID NUMBER (15) Yes
DOCUMENT_CODE VARCHAR2 (30) Yes
DOCUMENT_ID1 VARCHAR2 (100) Yes
DOCUMENT_ID2 VARCHAR2 (100) Yes
DOCUMENT_ID3 VARCHAR2 (100) Yes
DOCUMENT_ID4 VARCHAR2 (100) Yes
DOCUMENT_ID5 VARCHAR2 (100) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE
Yes
REFERENCE1 VARCHAR2 (255)
REFERENCE2 VARCHAR2 (255)
REFERENCE3 VARCHAR2 (255)
REFERENCE4 VARCHAR2 (255)
REFERENCE5 VARCHAR2 (255)
REFERENCE6 VARCHAR2 (255)
REFERENCE7 VARCHAR2 (255)
REFERENCE8 VARCHAR2 (255)
REFERENCE9 VARCHAR2 (255)
REFERENCE10 VARCHAR2 (255)
REFERENCE11 VARCHAR2 (255)
REFERENCE12 VARCHAR2 (255)
REFERENCE13 VARCHAR2 (255)
REFERENCE14 VARCHAR2 (255)
REFERENCE15 VARCHAR2 (255)
REFERENCE16 VARCHAR2 (255)
REFERENCE17 VARCHAR2 (255)
REFERENCE18 VARCHAR2 (255)
REFERENCE20 VARCHAR2 (255)
REFERENCE19 VARCHAR2 (255)
ORG_ID NUMBER

REFERENCE_NUM1 NUMBER

REFERENCE_NUM2 NUMBER

REFERENCE_NUM3 NUMBER

REFERENCE_NUM4 NUMBER

REFERENCE_NUM5 NUMBER

REFERENCE_NUM6 NUMBER

REFERENCE_NUM7 NUMBER

REFERENCE_NUM8 NUMBER

REFERENCE_NUM9 NUMBER

REFERENCE_NUM10 NUMBER

REFERENCE_DATE1 DATE

REFERENCE_DATE2 DATE

REFERENCE_DATE3 DATE

REFERENCE_DATE4 DATE

REFERENCE_DATE5 DATE

REFERENCE_DATE6 DATE

REFERENCE_DATE7 DATE

REFERENCE_DATE8 DATE

REFERENCE_DATE9 DATE

REFERENCE_DATE10 DATE

Query Text

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


SELECT APPLICATION_ID
,      SET_OF_BOOKS_ID
,      DOCUMENT_CODE
,      DOCUMENT_ID1
,      DOCUMENT_ID2
,      DOCUMENT_ID3
,      DOCUMENT_ID4
,      DOCUMENT_ID5
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      REFERENCE11
,      REFERENCE12
,      REFERENCE13
,      REFERENCE14
,      REFERENCE15
,      REFERENCE16
,      REFERENCE17
,      REFERENCE18
,      REFERENCE20
,      REFERENCE19
,      ORG_ID
,      REFERENCE_NUM1
,      REFERENCE_NUM2
,      REFERENCE_NUM3
,      REFERENCE_NUM4
,      REFERENCE_NUM5
,      REFERENCE_NUM6
,      REFERENCE_NUM7
,      REFERENCE_NUM8
,      REFERENCE_NUM9
,      REFERENCE_NUM10
,      REFERENCE_DATE1
,      REFERENCE_DATE2
,      REFERENCE_DATE3
,      REFERENCE_DATE4
,      REFERENCE_DATE5
,      REFERENCE_DATE6
,      REFERENCE_DATE7
,      REFERENCE_DATE8
,      REFERENCE_DATE9
,      REFERENCE_DATE10
FROM AX.AX_DOCUMENT_STATUSES#;

Dependencies

[top of page]

AX.AX_DOCUMENT_STATUSES# references the following:

SchemaAX
TableAX_DOCUMENT_STATUSES
AX.AX_DOCUMENT_STATUSES# is referenced by following:

SchemaAPPS
SynonymAX_DOCUMENT_STATUSES