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

TABLE: JTF.JTY_TRANS_USG_PGM_DETAILS

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


This table stores program details for bulk TAE.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000405595C00011$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000405595C00012$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
TRANS_USG_PGM_DETAILS_ID NUMBER
Yes Primary key
SOURCE_ID NUMBER
Yes Source ID
TRANS_TYPE_ID NUMBER
Yes Transaction type ID
PROGRAM_NAME VARCHAR2 (60) Yes Program name
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
PARAM_PASSING_MECHANISM VARCHAR2 (3)
Parameter passing mechanism
REAL_TIME_MATCH_SQL CLOB (4000)
Real time match SQL
REAL_TIME_MATCH_DEA_SQL CLOB (4000)
Real time match SQL for date effectivity assignment
REAL_TIME_ENABLE_FLAG VARCHAR2 (1)
Real time enable flag
BATCH_ENABLE_FLAG VARCHAR2 (1)
Batch enable flag
MULTI_LEVEL_WINNING_FLAG VARCHAR2 (1)
Multiple level winning flag
REAL_TIME_TRANS_TABLE_NAME VARCHAR2 (30)
Realtime transaction table name
BATCH_TRANS_TABLE_NAME VARCHAR2 (30)
Batch transaction table name
BATCH_NM_TRANS_TABLE_NAME VARCHAR2 (30)
Batch transaction table name in new mode
BATCH_DEA_TRANS_TABLE_NAME VARCHAR2 (30)
Batch transaction table name in date effectivity assignment
BATCH_MATCH_TABLE_NAME VARCHAR2 (30)
Batch match table name
BATCH_UNIQUE_MATCH_TABLE_NAME VARCHAR2 (30)
Batch unique match table name
BATCH_WINNER_TABLE_NAME VARCHAR2 (30)
Batch winner table name
BATCH_UNIQUE_WINNER_TABLE_NAME VARCHAR2 (30)
Batch unique winner table name
BATCH_L1_WINNER_TABLE_NAME VARCHAR2 (30)
Batch level 1 winner table name
BATCH_L2_WINNER_TABLE_NAME VARCHAR2 (30)
Batch level 2 winner table name
BATCH_L3_WINNER_TABLE_NAME VARCHAR2 (30)
Batch level 3 winner table name
BATCH_L4_WINNER_TABLE_NAME VARCHAR2 (30)
Batch level 4 winner table name
BATCH_L5_WINNER_TABLE_NAME VARCHAR2 (30)
Batch level 5 winner table name
BATCH_WT_WINNER_TABLE_NAME VARCHAR2 (30)
Batch WT winner table name
BATCH_MP_WINNER_TABLE_NAME VARCHAR2 (25)
Batch MP winner table name
BATCH_DMC_WINNER_TABLE_NAME VARCHAR2 (25)
Batch DMC winner table name
INDEX_EXTN VARCHAR2 (2)
Index extension
SECURITY_GROUP_ID NUMBER

used in hostd environments
OBJECT_VERSION_NUMBER NUMBER

Object version number
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT TRANS_USG_PGM_DETAILS_ID
,      SOURCE_ID
,      TRANS_TYPE_ID
,      PROGRAM_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PARAM_PASSING_MECHANISM
,      REAL_TIME_MATCH_SQL
,      REAL_TIME_MATCH_DEA_SQL
,      REAL_TIME_ENABLE_FLAG
,      BATCH_ENABLE_FLAG
,      MULTI_LEVEL_WINNING_FLAG
,      REAL_TIME_TRANS_TABLE_NAME
,      BATCH_TRANS_TABLE_NAME
,      BATCH_NM_TRANS_TABLE_NAME
,      BATCH_DEA_TRANS_TABLE_NAME
,      BATCH_MATCH_TABLE_NAME
,      BATCH_UNIQUE_MATCH_TABLE_NAME
,      BATCH_WINNER_TABLE_NAME
,      BATCH_UNIQUE_WINNER_TABLE_NAME
,      BATCH_L1_WINNER_TABLE_NAME
,      BATCH_L2_WINNER_TABLE_NAME
,      BATCH_L3_WINNER_TABLE_NAME
,      BATCH_L4_WINNER_TABLE_NAME
,      BATCH_L5_WINNER_TABLE_NAME
,      BATCH_WT_WINNER_TABLE_NAME
,      BATCH_MP_WINNER_TABLE_NAME
,      BATCH_DMC_WINNER_TABLE_NAME
,      INDEX_EXTN
,      SECURITY_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM JTF.JTY_TRANS_USG_PGM_DETAILS;

Dependencies

[top of page]

JTF.JTY_TRANS_USG_PGM_DETAILS does not reference any database object

JTF.JTY_TRANS_USG_PGM_DETAILS is referenced by following:

SchemaJTF
ViewJTY_TRANS_USG_PGM_DETAILS#