eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OKL.OKL_BOOK_CONTROL_TRX_ALL

Object Details

Object Name:	OKL_BOOK_CONTROL_TRX_ALL
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_BOOK_CONTROL_TRX_ALL
Subobject Name:
Status:	VALID

Book Controller transaction table stores user request and use those to submit concurrent programs to book a contract.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_BOOK_CONTROL_TRX_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_NUMBER KHR_ID PROG_SHORT_NAME
OKL_BOOK_CONTROL_TRX_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	KHR_ID PROGRESS_STATUS

Columns

Name	Datatype	Length	Mandatory	Comments
USER_ID	NUMBER		Yes	User identifier
ORG_ID	NUMBER		Yes	Authoring Organization identifier
BATCH_NUMBER	NUMBER		Yes	Booking request batch number
PROCESSING_SRL_NUMBER	NUMBER		Yes	Serial number to indicate processing sequence
KHR_ID	NUMBER		Yes	Contract header identifier
PROGRAM_NAME	VARCHAR2	(30)	Yes	Name of the program to run in booking sequence
PROG_SHORT_NAME	VARCHAR2	(30)	Yes	Short Name of the program to run in booking sequence
CONC_REQ_ID	NUMBER			Concurrent program request identifier
PROGRESS_STATUS	VARCHAR2	(30)	Yes	Progress status of the program
CREATED_BY	NUMBER			Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
ACTIVE_FLAG	VARCHAR2	(1)		The flag to identify records to be displayed in the UI booking summary page

Query Text

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


SELECT USER_ID
,      ORG_ID
,      BATCH_NUMBER
,      PROCESSING_SRL_NUMBER
,      KHR_ID
,      PROGRAM_NAME
,      PROG_SHORT_NAME
,      CONC_REQ_ID
,      PROGRESS_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ACTIVE_FLAG
FROM OKL.OKL_BOOK_CONTROL_TRX_ALL;

Dependencies

[top of page]

OKL.OKL_BOOK_CONTROL_TRX_ALL does not reference any database object

OKL.OKL_BOOK_CONTROL_TRX_ALL is referenced by following:

OKL: OKL_BOOK_CONTROL_TRX_ALL#