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

VIEW: AR.AR_DOCUMENT_TRANSFERS#

Object Details
Object Name: AR_DOCUMENT_TRANSFERS#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
DOCUMENT_TRANSFER_ID NUMBER (15) Yes
LAST_SUBMISSION_DATE DATE

CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
SOURCE_ID NUMBER (15) Yes
SOURCE_TABLE VARCHAR2 (30) Yes
TP_SOURCE_TABLE VARCHAR2 (30) Yes
TP_SOURCE_ID NUMBER (15)
STATUS VARCHAR2 (30) Yes
EVENT_NAME VARCHAR2 (200) Yes
ECX_TRX_TYPE VARCHAR2 (100)
ECX_TRX_SUBTYPE VARCHAR2 (100)
ECX_PARTY_TYPE VARCHAR2 (10)
EMAIL_ADDRESS VARCHAR2 (80)
DOCUMENT_MSGID RAW (16)
CONFIRMATION_MSGID RAW (16)
EXCEPTION_TYPE VARCHAR2 (30)
EXCEPTION_MESSAGE VARCHAR2 (2000)
REQUEST_ID NUMBER (15)
APPLICATION_ID NUMBER (15)
RESPONSIBILITY_ID NUMBER (15) Yes
Query Text

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


SELECT DOCUMENT_TRANSFER_ID
,      LAST_SUBMISSION_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      SOURCE_ID
,      SOURCE_TABLE
,      TP_SOURCE_TABLE
,      TP_SOURCE_ID
,      STATUS
,      EVENT_NAME
,      ECX_TRX_TYPE
,      ECX_TRX_SUBTYPE
,      ECX_PARTY_TYPE
,      EMAIL_ADDRESS
,      DOCUMENT_MSGID
,      CONFIRMATION_MSGID
,      EXCEPTION_TYPE
,      EXCEPTION_MESSAGE
,      REQUEST_ID
,      APPLICATION_ID
,      RESPONSIBILITY_ID
FROM AR.AR_DOCUMENT_TRANSFERS#;

Dependencies

[top of page]

AR.AR_DOCUMENT_TRANSFERS# references the following:

SchemaAR
TableAR_DOCUMENT_TRANSFERS
AR.AR_DOCUMENT_TRANSFERS# is referenced by following:

SchemaAPPS
SynonymAR_DOCUMENT_TRANSFERS