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

VIEW: OKS.OKS_STREAM_LEVELS_B#

Object Details
Object Name: OKS_STREAM_LEVELS_B#
Object Type: VIEW
Owner: OKS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
CHR_ID NUMBER

CLE_ID NUMBER

DNZ_CHR_ID NUMBER
Yes
SEQUENCE_NO NUMBER

UOM_CODE VARCHAR2 (3)
START_DATE DATE

END_DATE DATE

LEVEL_PERIODS NUMBER

UOM_PER_PERIOD NUMBER

ADVANCE_PERIODS NUMBER

LEVEL_AMOUNT NUMBER

INVOICE_OFFSET_DAYS NUMBER

INTERFACE_OFFSET_DAYS NUMBER

COMMENTS VARCHAR2 (2000)
DUE_ARR_YN VARCHAR2 (1)
AMOUNT NUMBER

LINES_DETAILED_YN VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER
Yes
SECURITY_GROUP_ID NUMBER

REQUEST_ID NUMBER

CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
ORIG_SYSTEM_ID1 NUMBER

ORIG_SYSTEM_REFERENCE1 VARCHAR2 (30)
ORIG_SYSTEM_SOURCE_CODE VARCHAR2 (30)
Query Text

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


SELECT ID
,      CHR_ID
,      CLE_ID
,      DNZ_CHR_ID
,      SEQUENCE_NO
,      UOM_CODE
,      START_DATE
,      END_DATE
,      LEVEL_PERIODS
,      UOM_PER_PERIOD
,      ADVANCE_PERIODS
,      LEVEL_AMOUNT
,      INVOICE_OFFSET_DAYS
,      INTERFACE_OFFSET_DAYS
,      COMMENTS
,      DUE_ARR_YN
,      AMOUNT
,      LINES_DETAILED_YN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      ORIG_SYSTEM_SOURCE_CODE
FROM OKS.OKS_STREAM_LEVELS_B#;

Dependencies

[top of page]

OKS.OKS_STREAM_LEVELS_B# references the following:

SchemaOKS
TableOKS_STREAM_LEVELS_B
OKS.OKS_STREAM_LEVELS_B# is referenced by following:

SchemaAPPS
SynonymOKS_STREAM_LEVELS_B