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

TABLE: OKC.OKC_K_SEQ_HEADER

Object Details
Object Name: OKC_K_SEQ_HEADER
Object Type: TABLE
Owner: OKC
FND Design Data: TableOKC.OKC_K_SEQ_HEADER
Subobject Name:
Status: VALID


Holds the configuration rules for Autonumbering setup


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
CREATION_DATE DATE
Yes Standard Who Column
LINE_CODE VARCHAR2 (30) Yes Line Cide
CLS_SCS_NONE VARCHAR2 (3) Yes Applicable to Class or Category or None.
USER_FUNCTION_YN VARCHAR2 (3) Yes User function indicator
MANUAL_OVERRIDE_YN VARCHAR2 (3) Yes Indicates whether can be used Manually or Autogenerated.
SITE_YN VARCHAR2 (3) Yes Site level indicator
BG_OU_NONE VARCHAR2 (3) Yes Applicable to Business Group or Operating Unit or None.
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
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
PDF_ID NUMBER

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 CREATION_DATE
,      LINE_CODE
,      CLS_SCS_NONE
,      USER_FUNCTION_YN
,      MANUAL_OVERRIDE_YN
,      SITE_YN
,      BG_OU_NONE
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      PDF_ID
,      SECURITY_GROUP_ID
FROM OKC.OKC_K_SEQ_HEADER;

Dependencies

[top of page]

OKC.OKC_K_SEQ_HEADER does not reference any database object

OKC.OKC_K_SEQ_HEADER is referenced by following:

SchemaAPPS
SynonymOKC_K_SEQ_HEADER