Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - JTS Tables and Views

TABLE - JTS.JTS_CONFIGURATIONS_B
TABLE - JTS.JTS_CONFIGURATIONS_TL
TABLE - JTS.JTS_CONFIG_SESSION_VALUES
TABLE - JTS.JTS_CONFIG_VERSIONS_B
TABLE - JTS.JTS_CONFIG_VERSIONS_TL
TABLE - JTS.JTS_CONFIG_VERSION_FLOWS
TABLE - JTS.JTS_CONFIG_VERSION_STATUSES
TABLE - JTS.JTS_FLOW_STEPS_B
TABLE - JTS.JTS_FLOW_STEPS_TL
TABLE - JTS.JTS_REPLAY_RESULTS_B
TABLE - JTS.JTS_SETUP_FLOWS_B
TABLE - JTS.JTS_SETUP_FLOWS_TL
VIEW - APPS.JTS_CONFIGURATIONS_VL
VIEW - APPS.JTS_CONFIG_VERSIONS_VL
VIEW - APPS.JTS_FLOW_STEPS_VL
VIEW - APPS.JTS_SETUP_FLOWS_VL

Table: JTS_CONFIGURATIONS_B

Description: Stores Configurations data. This is the starting point for configurations Management as delineated in My Configuration page.
Comments

Stores Configurations data. This is the starting point for Congurations Management as delineated in My Configurations page.

Indexes
Index Type Tablespace Column
JTS_CONFIGURATIONS_B_U1 UNIQUE APPS_TS_TX_IDX CONFIGURATION_ID
JTS_CONFIGURATIONS_B_U2 UNIQUE APPS_TS_TX_IDX CONFIG_NAME
JTS_CONFIGURATIONS_B_N1 NONUNIQUE APPS_TS_TX_IDX FLOW_ID
Columns
Name Datatype Length Mandatory Comments
CONFIGURATION_ID NUMBER
Y Configuration Id
CONFIG_NAME VARCHAR2 (80) Y configuration Name
FLOW_ID NUMBER
Y Flow Id
RECORD_MODE VARCHAR2 (30) Y record mode, could be xml, db, or xmldb
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute
ATTRIBUTE2 VARCHAR2 (150)
Attribute
ATTRIBUTE3 VARCHAR2 (150)
Attribute
ATTRIBUTE4 VARCHAR2 (150)
Attribute
ATTRIBUTE5 VARCHAR2 (150)
Attribute
ATTRIBUTE6 VARCHAR2 (150)
Attribute
ATTRIBUTE7 VARCHAR2 (150)
Attribute
ATTRIBUTE8 VARCHAR2 (150)
Attribute
ATTRIBUTE9 VARCHAR2 (150)
Attribute
ATTRIBUTE10 VARCHAR2 (150)
Attribute
ATTRIBUTE11 VARCHAR2 (150)
Attribute
ATTRIBUTE12 VARCHAR2 (150)
Attribute
ATTRIBUTE13 VARCHAR2 (150)
Attribute
ATTRIBUTE14 VARCHAR2 (150)
Attribute
ATTRIBUTE15 VARCHAR2 (150)
Attribute
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
SECURITY_GROUP_ID NUMBER (15)
Security Group Identifier

[top of page]

JTS.JTS_CONFIGURATIONS_B does not reference any database object

JTS.JTS_CONFIGURATIONS_B is referenced by following:

APPS
SYNONYM - JTS_CONFIGURATIONS_B

[top of page]

Table: JTS_CONFIGURATIONS_TL

Description:
Comments

Stores Configurations data. This is the starting point for Congurations Management as delineated in My Configurations page.

Indexes
Index Type Tablespace Column
JTS_CONFIGURATIONS_TL_U1 UNIQUE APPS_TS_TX_IDX CONFIGURATION_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
CONFIGURATION_ID NUMBER
Y Configuration Id
LANGUAGE VARCHAR2 (30) Y Language Code
SOURCE_LANG VARCHAR2 (4) Y Original Language Code
DESCRIPTION VARCHAR2 (240)
User Entered Description
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
SECURITY_GROUP_ID NUMBER (15)
Security Group Identifier

[top of page]

JTS.JTS_CONFIGURATIONS_TL does not reference any database object

JTS.JTS_CONFIGURATIONS_TL is referenced by following:

APPS
SYNONYM - JTS_CONFIGURATIONS_TL

[top of page]

Table: JTS_CONFIG_SESSION_VALUES

Description: Stores session-specific values that are needed for Configurations Management, i.e. queue name and record mode for each session.
Comments

Stores session-specific values that are needed for Configurations Management, i.e. queue name and record mode for each session.
Insert: When Start Setup is launched in Setup Summary page
Update: Allowed
Delete: when user exits the setup or goes to one of the configuration setup pages but is not in a DPF.

Indexes
Index Type Tablespace Column
JTS_CONFIG_SESSION_VALUES_U1 UNIQUE APPS_TS_TX_IDX SESSION_ID
Columns
Name Datatype Length Mandatory Comments
SESSION_ID NUMBER
Y Unique identifier
RECORD_MODE VARCHAR2 (30)
Lookup: JTS_RECORD_MODE
QUEUE_NAME VARCHAR2 (30)
Stores queue name used for current session. Queue name is used for setting the Authentication Profile for XML Services in product modules
VERSION_ID NUMBER

version Id
FLOW_ID NUMBER

Flow Id
CREATION_DATE DATE
Y Standard WHO column
CREATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_DATE DATE
Y Standard WHO column
LAST_UPDATED_BY NUMBER (15) Y Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
SECURITY_GROUP_ID NUMBER

Used in hosted environments

[top of page]

JTS.JTS_CONFIG_SESSION_VALUES does not reference any database object

JTS.JTS_CONFIG_SESSION_VALUES is referenced by following:

APPS
SYNONYM - JTS_CONFIG_SESSION_VALUES

[top of page]

Table: JTS_CONFIG_VERSIONS_B

Description: Stores Configuration Versions as described in Version Summary Page.
Comments

Stores Configuration Versions as described in Version Summary Page.

Indexes
Index Type Tablespace Column
JTS_CONFIG_VERSIONS_B_U1 UNIQUE APPS_TS_TX_IDX VERSION_ID
JTS_CONFIG_VERSIONS_B_U2 UNIQUE APPS_TS_TX_IDX CONFIGURATION_ID
VERSION_NAME
Columns
Name Datatype Length Mandatory Comments
VERSION_ID NUMBER
Y version id
OBJECT_VERSION_NUMBER NUMBER
Y object version number
VERSION_NAME VARCHAR2 (80) Y version name
CONFIGURATION_ID NUMBER
Y configuration id
VERSION_NUMBER NUMBER
Y indicate the version of a configuration
QUEUE_NAME VARCHAR2 (80)
aqueue name
VERSION_STATUS_CODE VARCHAR2 (30)
version status code
REPLAY_STATUS_CODE VARCHAR2 (30)
replay status code
REPLAYED_ON DATE

replayed on
REPLAYED_BY NUMBER (15)
replayed by
ATTRIBUTE_CATEGORY VARCHAR2 (150)
attribute category
ATTRIBUTE1 VARCHAR2 (150)
attribute
ATTRIBUTE2 VARCHAR2 (240)
attribute
ATTRIBUTE3 VARCHAR2 (150)
attribute
ATTRIBUTE4 VARCHAR2 (150)
attribute
ATTRIBUTE5 VARCHAR2 (150)
attribute
ATTRIBUTE6 VARCHAR2 (150)
attribute
ATTRIBUTE7 VARCHAR2 (150)
attribute
ATTRIBUTE8 VARCHAR2 (150)
attribute
ATTRIBUTE9 VARCHAR2 (150)
attribute
ATTRIBUTE10 VARCHAR2 (150)
attribute
ATTRIBUTE11 VARCHAR2 (150)
attribute
ATTRIBUTE12 VARCHAR2 (150)
attribute
ATTRIBUTE13 VARCHAR2 (150)
attribute
ATTRIBUTE14 VARCHAR2 (150)
attribute
ATTRIBUTE15 VARCHAR2 (150)
attribute
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
SECURITY_GROUP_ID NUMBER (15)
security group identifier

[top of page]

JTS.JTS_CONFIG_VERSIONS_B does not reference any database object

JTS.JTS_CONFIG_VERSIONS_B is referenced by following:

APPS
SYNONYM - JTS_CONFIG_VERSIONS_B

[top of page]

Table: JTS_CONFIG_VERSIONS_TL

Description: Stores Configuration Versions as described in Version Summary Page. Translated Table.
Comments

Stores Configuration Versions as described in Version Summary Page. Translated Table.

Indexes
Index Type Tablespace Column
JTS_CONFIG_VERSIONS_TL_U1 UNIQUE APPS_TS_TX_IDX VERSION_ID
LANGUAGE
JTS_CONFIG_VERSIONS_TL_N1 NONUNIQUE APPS_TS_TX_IDX CONFIGURATION_ID
Columns
Name Datatype Length Mandatory Comments
VERSION_ID NUMBER
Y version id
CONFIGURATION_ID NUMBER
Y configuration id
LANGUAGE VARCHAR2 (30) Y The language code of the language which the translatable fields are translated to
SOURCE_LANG VARCHAR2 (4) Y Language code of the language which the values of the translatable columns were originally entered
DESCRIPTION VARCHAR2 (240)
description of this version of configuration
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
SECURITY_GROUP_ID NUMBER (15)
security group identifier

[top of page]

JTS.JTS_CONFIG_VERSIONS_TL does not reference any database object

JTS.JTS_CONFIG_VERSIONS_TL is referenced by following:

APPS
SYNONYM - JTS_CONFIG_VERSIONS_TL

[top of page]

Table: JTS_CONFIG_VERSION_FLOWS

Description:
Comments

Setup Summary page that stores last modifefied and complete flag

Indexes
Index Type Tablespace Column
JTS_CONFIG_VERSION_FLOWS_U1 UNIQUE APPS_TS_TX_IDX VERSION_ID
FLOW_ID
Columns
Name Datatype Length Mandatory Comments
VERSION_ID NUMBER
Y Version Id
FLOW_ID NUMBER
Y Flow Id
COMPLETE_FLAG VARCHAR2 (1)
Indication of completeness of the flow setup. 'Y' or 'N', 'N'=Null
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
SECURITY_GROUP_ID NUMBER (15)
Security Group Identifier
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number

[top of page]

JTS.JTS_CONFIG_VERSION_FLOWS does not reference any database object

JTS.JTS_CONFIG_VERSION_FLOWS is referenced by following:

APPS
SYNONYM - JTS_CONFIG_VERSION_FLOWS

[top of page]

Table: JTS_CONFIG_VERSION_STATUSES

Description:
Comments

STore version replay, download, upload statuses and progress.

Indexes
Index Type Tablespace Column
JTS_CONFIG_VERSION_STATUSES_N1 NONUNIQUE APPS_TS_TX_IDX VERSION_ID
Columns
Name Datatype Length Mandatory Comments
VERSION_ID NUMBER
Y Version Id
STATUS_CODE VARCHAR2 (30)
Status Code
CREATION_DATE DATE
Y Standard Who Column
CREATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_DATE DATE
Y Standard Who Column
LAST_UPDATED_BY NUMBER (15) Y Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
OBJECT_VERSION_NUMBER NUMBER
Y Object Version Number
SECURITY_GROUP_ID NUMBER (15)
Security Group Identifier

[top of page]

JTS.JTS_CONFIG_VERSION_STATUSES does not reference any database object

JTS.JTS_CONFIG_VERSION_STATUSES is referenced by following:

APPS
SYNONYM - JTS_CONFIG_VERSION_STATUSES

[top of page]

Table: JTS_FLOW_STEPS_B

Description: Stores details of all setup steps that comprise that subflow
Comments

Stores details of all setup steps that comprise that subflow

Indexes
Index Type Tablespace Column
JTS_FLOW_STEPS_B_U1 UNIQUE APPS_TS_SEED STEP_ID
JTS_FLOW_STEPS_B_N1 NONUNIQUE APPS_TS_SEED FLOW_ID
Columns
Name Datatype Length Mandatory Comments
STEP_ID NUMBER
Y step id
FLOW_ID NUMBER
Y flow id
MANDATORY_FLAG VARCHAR2 (1) Y indicates the step is manadatory or optional
CONCURRENT_FLAG VARCHAR2 (1) Y indicates if the step will submit a concurrent program
STEP_SEQUENCE NUMBER
Y sequence
SETUP_PAGE VARCHAR2 (240)
setup page
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
SECURITY_GROUP_ID NUMBER (15)
security group identifier

[top of page]

JTS.JTS_FLOW_STEPS_B does not reference any database object

JTS.JTS_FLOW_STEPS_B is referenced by following:

APPS
SYNONYM - JTS_FLOW_STEPS_B

[top of page]

Table: JTS_FLOW_STEPS_TL

Description: Stores details of all setup steps that comprise that subflow. Translated Table.
Comments

Stores details of all setup steps that comprise that subflow. Translated Table.

Indexes
Index Type Tablespace Column
JTS_FLOW_STEPS_TL_U1 UNIQUE APPS_TS_SEED STEP_ID
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
STEP_ID NUMBER
Y step id
LANGUAGE VARCHAR2 (30) Y The language code of the language which the translatable fields are translated to
SOURCE_LANG VARCHAR2 (4) Y Language code of the language which the values of the translatable columns were originally entered
STEP_NAME VARCHAR2 (80) Y step name
DESCRIPTION VARCHAR2 (2000) Y indicates a brief description of the step
IMPACT VARCHAR2 (2000) Y indicates the impact of completing the configuration of that step
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
SECURITY_GROUP_ID NUMBER (15)
security group identifier

[top of page]

JTS.JTS_FLOW_STEPS_TL does not reference any database object

JTS.JTS_FLOW_STEPS_TL is referenced by following:

APPS
SYNONYM - JTS_FLOW_STEPS_TL

[top of page]

Table: JTS_REPLAY_RESULTS_B

Description: Stores status and error infomation of replay
Comments

Stores status and error infomation of replay

Indexes
Index Type Tablespace Column
JTS_REPLAY_RESULTS_B_N1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
VERSION_ID
FLOW_ID
Columns
Name Datatype Length Mandatory Comments
REQUEST_ID NUMBER
Y request_id of concurrent request
VERSION_ID NUMBER
Y version_id of version being replayed
FLOW_ID NUMBER
Y flow_id of sub flow of a version
INV_NAME VARCHAR2 (50) Y invocation name
STATUS VARCHAR2 (80)
replay status: succeed or fail
ERROR_NUMBER NUMBER

error number
MODE_CODE VARCHAR2 (15)
mode of replay: insert, update, delete
ERROR_MESSAGE VARCHAR2 (2000)
error message
EXCEPTION VARCHAR2 (2000)
exception message
PRIMARY_KEY_ID VARCHAR2 (240)
primary key id's of the base table
PRIMARY_KEY_NAME VARCHAR2 (240)
primary key name(s) of the base table
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
SECURITY_GROUP_ID NUMBER (15)
security group id
OBJECT_VERSION_NUMBER NUMBER
Y object version number

[top of page]

JTS.JTS_REPLAY_RESULTS_B does not reference any database object

JTS.JTS_REPLAY_RESULTS_B is referenced by following:

APPS
SYNONYM - JTS_REPLAY_RESULTS_B

[top of page]

Table: JTS_SETUP_FLOWS_B

Description: Stores subflow hierarchy as shown in Setup Summary Page.
Comments

Stores subflow hierarchy as shown in Setup Summary Page.

Indexes
Index Type Tablespace Column
JTS_SETUP_FLOWS_B_U1 UNIQUE APPS_TS_SEED FLOW_ID
JTS_SETUP_FLOWS_B_U2 UNIQUE APPS_TS_SEED FLOW_CODE
JTS_SETUP_FLOWS_B_N1 NONUNIQUE APPS_TS_SEED PARENT_ID
JTS_SETUP_FLOWS_B_N2 NONUNIQUE APPS_TS_SEED FLOW_TYPE
Columns
Name Datatype Length Mandatory Comments
FLOW_ID NUMBER
Y flow id
FLOW_CODE VARCHAR2 (30) Y flow code
FLOW_TYPE VARCHAR2 (30)
indicate the flow type
PARENT_ID NUMBER

indicate the parent flow id
HAS_CHILD_FLAG VARCHAR2 (1)
indicate if current flow has subflow or not
FLOW_SEQUENCE NUMBER
Y sequence number
OVERVIEW_URL VARCHAR2 (240)
url of overview page
DIAGNOSTICS_URL VARCHAR2 (240)
url of diagnostics page
DPF_CODE VARCHAR2 (50)
code used for launching dpf flow
DPF_ASN VARCHAR2 (50)
asn used for launching dpf flow
NUM_STEPS NUMBER

number of steps for dpf flow
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
SECURITY_GROUP_ID NUMBER (15)
security group identifier
OBJECT_VERSION_NUMBER NUMBER
Y object version number

[top of page]

JTS.JTS_SETUP_FLOWS_B does not reference any database object

JTS.JTS_SETUP_FLOWS_B is referenced by following:

APPS
SYNONYM - JTS_SETUP_FLOWS_B

[top of page]

Table: JTS_SETUP_FLOWS_TL

Description: Stores subflow hierarchy as shown in Setup Summary Page. Translated Table.
Comments

Stores subflow hierarchy as shown in Setup Summary Page. Translated Table.

Indexes
Index Type Tablespace Column
JTS_SETUP_FLOWS_TL_U1 UNIQUE APPS_TS_SEED FLOW_ID
LANGUAGE
JTS_SETUP_FLOWS_TL_U2 UNIQUE APPS_TS_SEED FLOW_CODE
LANGUAGE
Columns
Name Datatype Length Mandatory Comments
FLOW_ID NUMBER
Y flow id
FLOW_CODE VARCHAR2 (30) Y flow code
LANGUAGE VARCHAR2 (30) Y The language code of the language which the translatable fields are translated to
SOURCE_LANG VARCHAR2 (4) Y Language code of the language which the values of the translatable columns were originally entered
FLOW_NAME VARCHAR2 (80) Y flow name
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (5) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column
SECURITY_GROUP_ID NUMBER (15)
security group identifier

[top of page]

JTS.JTS_SETUP_FLOWS_TL does not reference any database object

JTS.JTS_SETUP_FLOWS_TL is referenced by following:

APPS
SYNONYM - JTS_SETUP_FLOWS_TL

[top of page]

View: JTS_CONFIGURATIONS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Stores Configuration Data

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
row id
CONFIGURATION_ID NUMBER
Y configuration id
CONFIG_NAME VARCHAR2 (80) Y configuration name
FLOW_ID NUMBER
Y flow id
RECORD_MODE VARCHAR2 (30) Y record mode
DESCRIPTION VARCHAR2 (240)
description
OBJECT_VERSION_NUMBER NUMBER
Y object version number
ATTRIBUTE_CATEGORY VARCHAR2 (150)
attribute category
ATTRIBUTE1 VARCHAR2 (150)
attribute
ATTRIBUTE2 VARCHAR2 (150)
attribute
ATTRIBUTE3 VARCHAR2 (150)
attribute
ATTRIBUTE4 VARCHAR2 (150)
attribute
ATTRIBUTE5 VARCHAR2 (150)
attribute
ATTRIBUTE6 VARCHAR2 (150)
attribute
ATTRIBUTE7 VARCHAR2 (150)
attribute
ATTRIBUTE8 VARCHAR2 (150)
attribute
ATTRIBUTE9 VARCHAR2 (150)
attribute
ATTRIBUTE10 VARCHAR2 (150)
attribute
ATTRIBUTE11 VARCHAR2 (150)
attribute
ATTRIBUTE12 VARCHAR2 (150)
attribute
ATTRIBUTE13 VARCHAR2 (150)
attribute
ATTRIBUTE14 VARCHAR2 (150)
attribute
ATTRIBUTE15 VARCHAR2 (150)
attribute
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column

[top of page]

APPS.JTS_CONFIGURATIONS_VL references the following:

APPS
SYNONYM - JTS_CONFIGURATIONS_B
SYNONYM - JTS_CONFIGURATIONS_TL
APPS.JTS_CONFIGURATIONS_VL is referenced by following:

APPS
PACKAGE BODY - JTS_CONFIGURATION_PVT

[top of page]

View: JTS_CONFIG_VERSIONS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Store Configuration Versions as described in Versions Summary page

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
row id
VERSION_ID NUMBER
Y version id
VERSION_NAME VARCHAR2 (80) Y version name
CONFIGURATION_ID NUMBER
Y configuration id
DESCRIPTION VARCHAR2 (240)
description
VERSION_NUMBER NUMBER
Y version number
QUEUE_NAME VARCHAR2 (80)
aqueue name
VERSION_STATUS_CODE VARCHAR2 (30)
version status code
REPLAY_STATUS_CODE VARCHAR2 (30)
replay status code
REPLAYED_ON DATE

replayed on
REPLAYED_BY NUMBER (15)
replayed by
OBJECT_VERSION_NUMBER NUMBER
Y object version number
ATTRIBUTE_CATEGORY VARCHAR2 (150)
attribute category
ATTRIBUTE1 VARCHAR2 (150)
attribute
ATTRIBUTE2 VARCHAR2 (240)
attribute
ATTRIBUTE3 VARCHAR2 (150)
attribute
ATTRIBUTE4 VARCHAR2 (150)
attribute
ATTRIBUTE5 VARCHAR2 (150)
attribute
ATTRIBUTE6 VARCHAR2 (150)
attribute
ATTRIBUTE7 VARCHAR2 (150)
attribute
ATTRIBUTE8 VARCHAR2 (150)
attribute
ATTRIBUTE9 VARCHAR2 (150)
attribute
ATTRIBUTE10 VARCHAR2 (150)
attribute
ATTRIBUTE11 VARCHAR2 (150)
attribute
ATTRIBUTE12 VARCHAR2 (150)
attribute
ATTRIBUTE13 VARCHAR2 (150)
attribute
ATTRIBUTE14 VARCHAR2 (150)
attribute
ATTRIBUTE15 VARCHAR2 (150)
attribute
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column

[top of page]

APPS.JTS_CONFIG_VERSIONS_VL references the following:

APPS
SYNONYM - JTS_CONFIG_VERSIONS_B
SYNONYM - JTS_CONFIG_VERSIONS_TL
APPS.JTS_CONFIG_VERSIONS_VL is referenced by following:

APPS
PACKAGE BODY - JTS_CONFIG_VERSION_PVT

[top of page]

View: JTS_FLOW_STEPS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Stores details of all setup steps that comprise that subflow

Columns
Name Datatype Length Mandatory Comments
SETUP_PAGE VARCHAR2 (240)
setup page
STEP_ID NUMBER
Y step id
FLOW_ID NUMBER
Y flow id
MANDATORY_FLAG VARCHAR2 (1) Y mandatory flag
CONCURRENT_FLAG VARCHAR2 (1) Y concurrent flag
STEP_SEQUENCE NUMBER
Y step sequence
STEP_NAME VARCHAR2 (80) Y step name
DESCRIPTION VARCHAR2 (2000) Y description
IMPACT VARCHAR2 (2000) Y impact
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column

[top of page]

APPS.JTS_FLOW_STEPS_VL references the following:

APPS
SYNONYM - JTS_FLOW_STEPS_B
SYNONYM - JTS_FLOW_STEPS_TL

APPS.JTS_FLOW_STEPS_VL is not referenced by any database object

[top of page]

View: JTS_SETUP_FLOWS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Stores subflow hierarchy as shown in setup Summary page.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
row id
FLOW_ID NUMBER
Y flow id
FLOW_NAME VARCHAR2 (80) Y flow name
FLOW_CODE VARCHAR2 (30) Y flow code
FLOW_TYPE VARCHAR2 (30)
flow type
PARENT_ID NUMBER

parent id
HAS_CHILD_FLAG VARCHAR2 (1)
has child flag
FLOW_SEQUENCE NUMBER
Y flow sequence
OVERVIEW_URL VARCHAR2 (240)
overview url
DIAGNOSTICS_URL VARCHAR2 (240)
diagnostics url
DPF_CODE VARCHAR2 (50)
dpf code
DPF_ASN VARCHAR2 (50)
dpf asn
NUM_STEPS NUMBER

number of steps
OBJECT_VERSION_NUMBER NUMBER
Y object version number
CREATION_DATE DATE
Y standard who column
CREATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_DATE DATE
Y standard who column
LAST_UPDATED_BY NUMBER (15) Y standard who column
LAST_UPDATE_LOGIN NUMBER (15)
standard who column

[top of page]

APPS.JTS_SETUP_FLOWS_VL references the following:

APPS
SYNONYM - JTS_SETUP_FLOWS_B
SYNONYM - JTS_SETUP_FLOWS_TL
APPS.JTS_SETUP_FLOWS_VL is referenced by following:

APPS
PACKAGE BODY - JTS_CONFIGURATION_PVT
PACKAGE BODY - JTS_SETUP_FLOW_PVT

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract