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

VIEW: OKS.OKS_PRICE_BREAKS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
BSL_ID NUMBER

BCL_ID NUMBER

CLE_ID NUMBER

CHR_ID NUMBER

LINE_DETAIL_INDEX NUMBER

LINE_INDEX NUMBER

PRICING_CONTEXT VARCHAR2 (30)
PRICING_METHOD VARCHAR2 (2500)
QUANTITY_FROM NUMBER

QUANTITY_TO NUMBER

QUANTITY NUMBER

BREAK_UOM VARCHAR2 (30)
PRORATE VARCHAR2 (30)
UNIT_PRICE NUMBER

AMOUNT NUMBER

PRICE_LIST_ID NUMBER

VALIDATED_FLAG VARCHAR2 (1)
STATUS_CODE VARCHAR2 (30)
STATUS_TEXT VARCHAR2 (240)
LOCK_FLAG VARCHAR2 (1)
LOCKED_PRICE_LIST_ID NUMBER

LOCKED_PRICE_LIST_LINE_ID NUMBER

PRICE_LIST_LINE_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER
Yes
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)
Query Text

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


SELECT ID
,      BSL_ID
,      BCL_ID
,      CLE_ID
,      CHR_ID
,      LINE_DETAIL_INDEX
,      LINE_INDEX
,      PRICING_CONTEXT
,      PRICING_METHOD
,      QUANTITY_FROM
,      QUANTITY_TO
,      QUANTITY
,      BREAK_UOM
,      PRORATE
,      UNIT_PRICE
,      AMOUNT
,      PRICE_LIST_ID
,      VALIDATED_FLAG
,      STATUS_CODE
,      STATUS_TEXT
,      LOCK_FLAG
,      LOCKED_PRICE_LIST_ID
,      LOCKED_PRICE_LIST_LINE_ID
,      PRICE_LIST_LINE_ID
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKS.OKS_PRICE_BREAKS#;

Dependencies

[top of page]

OKS.OKS_PRICE_BREAKS# references the following:

SchemaOKS
TableOKS_PRICE_BREAKS
OKS.OKS_PRICE_BREAKS# is referenced by following:

SchemaAPPS
SynonymOKS_PRICE_BREAKS