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

VIEW: ONT.OE_EM_INFORMATION_ALL#

Object Details
Object Name: OE_EM_INFORMATION_ALL#
Object Type: VIEW
Owner: ONT
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORDER_SOURCE_ID NUMBER

ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
SOLD_TO_ORG_ID NUMBER

EM_TRANSACTION_TYPE_CODE VARCHAR2 (30)
DOCUMENT_ID NUMBER

PARENT_DOCUMENT_ID NUMBER

ORDER_NUMBER NUMBER

ORDER_TYPE_ID NUMBER

CHANGE_SEQUENCE VARCHAR2 (50)
ORG_ID NUMBER

HEADER_ID NUMBER

EM_CONC_REQUEST_ID NUMBER

DOCUMENT_STATUS VARCHAR2 (240)
DOCUMENT_DISPOSITION VARCHAR2 (20)
MESSAGE_TEXT VARCHAR2 (2000)
ITEM_TYPE VARCHAR2 (8)
ITEM_KEY VARCHAR2 (240)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

LAST_UPDATE_ITEMKEY VARCHAR2 (240)
Query Text

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


SELECT ORDER_SOURCE_ID
,      ORIG_SYS_DOCUMENT_REF
,      SOLD_TO_ORG_ID
,      EM_TRANSACTION_TYPE_CODE
,      DOCUMENT_ID
,      PARENT_DOCUMENT_ID
,      ORDER_NUMBER
,      ORDER_TYPE_ID
,      CHANGE_SEQUENCE
,      ORG_ID
,      HEADER_ID
,      EM_CONC_REQUEST_ID
,      DOCUMENT_STATUS
,      DOCUMENT_DISPOSITION
,      MESSAGE_TEXT
,      ITEM_TYPE
,      ITEM_KEY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      LAST_UPDATE_ITEMKEY
FROM ONT.OE_EM_INFORMATION_ALL#;

Dependencies

[top of page]

ONT.OE_EM_INFORMATION_ALL# references the following:

SchemaONT
TableOE_EM_INFORMATION_ALL
ONT.OE_EM_INFORMATION_ALL# is referenced by following:

SchemaAPPS
SynonymOE_EM_INFORMATION
SynonymOE_EM_INFORMATION_ALL