Skip to content

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

VIEW: OKS.OKS_CON_COV_LEVELS_INT_ALL#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
CONTRACT_LINE_ID NUMBER
Yes
COVERED_LEVEL_LINE_ID NUMBER
Yes
LINE_NUMBER VARCHAR2 (150)
COVERED_ITEM_ID NUMBER

COVERED_ITEM_ORG_ID NUMBER

COVERED_PARTY_ID NUMBER

COVERED_PRODUCT_ID NUMBER

COVERED_SITE_ID NUMBER

COVERED_SYSTEM_ID NUMBER

COVERED_CUSTOMER_ID NUMBER

LINE_REF VARCHAR2 (300)
LINE_STATUS_CODE VARCHAR2 (30)
START_DATE DATE
Yes
END_DATE DATE
Yes
RENEWAL_TYPE VARCHAR2 (100)
INVOICE_TEXT VARCHAR2 (300)
INVOICE_PRINT_FLAG VARCHAR2 (1)
ATTRIBUTE_CATEGORY VARCHAR2 (90)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
PRICING_CONTEXT VARCHAR2 (90)
PRICING_ATTRIBUTE1 VARCHAR2 (720)
PRICING_ATTRIBUTE2 VARCHAR2 (720)
PRICING_ATTRIBUTE3 VARCHAR2 (720)
PRICING_ATTRIBUTE4 VARCHAR2 (720)
PRICING_ATTRIBUTE5 VARCHAR2 (720)
PRICING_ATTRIBUTE6 VARCHAR2 (720)
PRICING_ATTRIBUTE7 VARCHAR2 (720)
PRICING_ATTRIBUTE8 VARCHAR2 (720)
PRICING_ATTRIBUTE9 VARCHAR2 (720)
PRICING_ATTRIBUTE10 VARCHAR2 (720)
PRICING_ATTRIBUTE11 VARCHAR2 (720)
PRICING_ATTRIBUTE12 VARCHAR2 (720)
PRICING_ATTRIBUTE13 VARCHAR2 (720)
PRICING_ATTRIBUTE14 VARCHAR2 (720)
PRICING_ATTRIBUTE15 VARCHAR2 (720)
QUANTITY NUMBER

UNIT_OF_MEASURE_CODE VARCHAR2 (30)
PRICE_LIST_ID NUMBER

PRICE_UNIT NUMBER

PRICE_NEGOTIATED NUMBER

PRICE_UNIT_PERCENT NUMBER

INTERFACED_STATUS_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (30)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT CONTRACT_LINE_ID
,      COVERED_LEVEL_LINE_ID
,      LINE_NUMBER
,      COVERED_ITEM_ID
,      COVERED_ITEM_ORG_ID
,      COVERED_PARTY_ID
,      COVERED_PRODUCT_ID
,      COVERED_SITE_ID
,      COVERED_SYSTEM_ID
,      COVERED_CUSTOMER_ID
,      LINE_REF
,      LINE_STATUS_CODE
,      START_DATE
,      END_DATE
,      RENEWAL_TYPE
,      INVOICE_TEXT
,      INVOICE_PRINT_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      QUANTITY
,      UNIT_OF_MEASURE_CODE
,      PRICE_LIST_ID
,      PRICE_UNIT
,      PRICE_NEGOTIATED
,      PRICE_UNIT_PERCENT
,      INTERFACED_STATUS_FLAG
,      CURRENCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKS.OKS_CON_COV_LEVELS_INT_ALL#;

Dependencies

[top of page]

OKS.OKS_CON_COV_LEVELS_INT_ALL# references the following:

SchemaOKS
TableOKS_CON_COV_LEVELS_INT_ALL
OKS.OKS_CON_COV_LEVELS_INT_ALL# is referenced by following:

SchemaAPPS
SynonymOKS_CON_COV_LEVELS_INT_ALL