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

TABLE: JTF.JTF_MESSAGE_OBJECTS

Object Details
Object Name: JTF_MESSAGE_OBJECTS
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_MESSAGE_OBJECTS
Subobject Name:
Status: VALID


Stores all Business object Definitions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000084343C00006$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000084343C00008$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
MSG_MODE NUMBER
Yes Represent messasge mode
BUS_OBJ_ID NUMBER

business object id
PRODUCT_CODE VARCHAR2 (10) Yes product code to which bo belongs
BUS_OBJ_CODE VARCHAR2 (10) Yes BO code
BUS_OBJ_NAME VARCHAR2 (50)
Bo name description
BUS_OBJ_SQL CLOB (4000)
BO sql
OBJ_GENERATOR VARCHAR2 (500)
Procedure Name for BO manipulation
BUS_OBJ_DTD CLOB (4000)
Business Object DTD
ACTIVE_FLAG VARCHAR2 (1)
Active flag 'Y/N'
ACTION_CODE VARCHAR2 (1) Yes Action code - insert/delete/update ( I / D / U )
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE1 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (50)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (50)
Descriptive flexfield segment
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT MSG_MODE
,      BUS_OBJ_ID
,      PRODUCT_CODE
,      BUS_OBJ_CODE
,      BUS_OBJ_NAME
,      BUS_OBJ_SQL
,      OBJ_GENERATOR
,      BUS_OBJ_DTD
,      ACTIVE_FLAG
,      ACTION_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ZD_EDITION_NAME
FROM JTF.JTF_MESSAGE_OBJECTS;

Dependencies

[top of page]

JTF.JTF_MESSAGE_OBJECTS does not reference any database object

JTF.JTF_MESSAGE_OBJECTS is referenced by following:

SchemaJTF
ViewJTF_MESSAGE_OBJECTS#