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: OKC.OKC_K_SEQ_LINES

Object Details

Object Name:	OKC_K_SEQ_LINES
Object Type:	TABLE
Owner:	OKC
FND Design Data:	OKC.OKC_K_SEQ_LINES
Subobject Name:
Status:	VALID

Holds the detail records for Autonumbering configuration

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
ID	NUMBER		Yes	Surrogate key used for primary key identifier
LINE_CODE	VARCHAR2	(30)	Yes	Line code
DOC_SEQUENCE_ID	NUMBER		Yes	Document sequence id
MANUAL_OVERRIDE_YN	VARCHAR2	(3)	Yes	Indicates whether can be used Manually or Autogenerated.
OPERATING_UNIT_ID	NUMBER	(15)		Operating Unit Identifier.
BUSINESS_GROUP_ID	NUMBER	(15)		Business Unit Identifier.
CLS_CODE	VARCHAR2	(30)		The Class Code
SCS_CODE	VARCHAR2	(30)		Category or Subclass Code
CONTRACT_NUMBER_PREFIX	VARCHAR2	(20)		The Starting Characters for the Number
CONTRACT_NUMBER_SUFFIX	VARCHAR2	(20)		The Trailing Characters for the Number
NUMBER_FORMAT_LENGTH	NUMBER	(3)		Format length for contract number
START_SEQ_NO	NUMBER			Sequence Number to Start
END_SEQ_NO	NUMBER			Sequence Number to End.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Sequential Number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT ID
,      LINE_CODE
,      DOC_SEQUENCE_ID
,      MANUAL_OVERRIDE_YN
,      OPERATING_UNIT_ID
,      BUSINESS_GROUP_ID
,      CLS_CODE
,      SCS_CODE
,      CONTRACT_NUMBER_PREFIX
,      CONTRACT_NUMBER_SUFFIX
,      NUMBER_FORMAT_LENGTH
,      START_SEQ_NO
,      END_SEQ_NO
,      OBJECT_VERSION_NUMBER
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      SECURITY_GROUP_ID
FROM OKC.OKC_K_SEQ_LINES;

Dependencies

[top of page]

OKC.OKC_K_SEQ_LINES does not reference any database object

OKC.OKC_K_SEQ_LINES is referenced by following:

APPS: OKC_K_SEQ_LINES