[Home] [Help] [Dependency Information]
Object Name: | OKS_PM_STREAM_LEVELS_H |
---|---|
Object Type: | TABLE |
Owner: | OKS |
Subobject Name: | |
Status: | VALID |
This is a mirror image of base table OKS_PM_STREAM_LEVELS, please refer to the base table for detailed column level information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKS_PM_STREAM_LEVELS_H_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ID
MAJOR_VERSION |
OKS_PM_STREAM_LEVELS_H_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DNZ_CHR_ID |
OKS_PM_STREAM_LEVELS_H_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CLE_ID |
OKS_PM_STREAM_LEVELS_H_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ACTIVITY_LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Unique Identifier for records in OKS_PM_STREAM_LEVELS | |
CLE_ID | NUMBER | Unique Identifier for Contract Line. Specifies the Contract line to which this stream level applies. Contract Line is a Coverage line. (References OKC_K_LINES_B.ID). | ||
DNZ_CHR_ID | NUMBER | Unique Identifier for Contract Header, denormalized for efficiency | ||
ACTIVITY_LINE_ID | NUMBER | Unique Identifier of PM Activity record (References OKS_PM_ACTIVITIES.ID) | ||
SEQUENCE_NUMBER | NUMBER | Chronological sequence of the stream levels associated with a program or activity. User enters the value for the column. | ||
NUMBER_OF_OCCURENCES | NUMBER | Total Number of schedules to perform for a stream level. | ||
START_DATE | DATE | Start Date of the stream level. The value is start date of the contract line for the first record and end date of the previous stream plus one day for subsequent records. | ||
END_DATE | DATE | End Date of the stream level. | ||
FREQUENCY | NUMBER | Frequency for the stream level | ||
FREQUENCY_UOM | VARCHAR2 | (3) | Units of measure of the frequency for the stream level | |
OFFSET_DURATION | NUMBER | Duration by which the first schedule is offset from START_DATE. Subsequent schedules are derived based on FREQUENCY and FREQUENCY_UOM. | ||
OFFSET_UOM | VARCHAR2 | (3) | Units Of Measure for OFFSET_DURATION. | |
AUTOSCHEDULE_YN | VARCHAR2 | (1) | Flag to indicate if schedules are auto generated or manually entered. | |
PROGRAM_APPLICATION_ID | NUMBER | With PROGRAM_ID, keeps track of which concurrent program created or updated each row | ||
PROGRAM_ID | NUMBER | With PROGRAM_APPLICATION_ID, keeps track of which concurrent program created or updated each row | ||
PROGRAM_UPDATE_DATE | DATE | Date the concurrent program updated the record | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed. | |
SECURITY_GROUP_ID | NUMBER | Now obsolete. Used to create a Virtual Private Database which was originally designed to be used by Hosting services. | ||
REQUEST_ID | NUMBER | Unique Identifier of a concurrent request | ||
CREATED_BY | NUMBER | (15) | Yes | ID of the user who created the record |
CREATION_DATE | DATE | Yes | Date the record was created | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | ID of the last user who updated the record |
LAST_UPDATE_DATE | DATE | Yes | Date the record was last updated | |
LAST_UPDATE_LOGIN | NUMBER | (15) | OS ID of the user who last updated the record | |
MAJOR_VERSION | NUMBER | Yes | Version of the contract line that got created as History. |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, CLE_ID
, DNZ_CHR_ID
, ACTIVITY_LINE_ID
, SEQUENCE_NUMBER
, NUMBER_OF_OCCURENCES
, START_DATE
, END_DATE
, FREQUENCY
, FREQUENCY_UOM
, OFFSET_DURATION
, OFFSET_UOM
, AUTOSCHEDULE_YN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, REQUEST_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MAJOR_VERSION
FROM OKS.OKS_PM_STREAM_LEVELS_H;
OKS.OKS_PM_STREAM_LEVELS_H does not reference any database object
OKS.OKS_PM_STREAM_LEVELS_H is referenced by following:
|
|
|