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

TABLE: OZF.OZF_RETAIL_PRICE_POINTS

Object Details
Object Name: OZF_RETAIL_PRICE_POINTS
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_RETAIL_PRICE_POINTS
Subobject Name:
Status: VALID


This table stores the retail price information for products


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_RETAIL_PRICE_POINTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
OZF_RETAIL_PRICE_POINTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROOT_RETAIL_PRICE_POINT_ID
OZF_RETAIL_PRICE_POINTS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
OZF_RETAIL_PRICE_POINTS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRETAIL_PRICE_POINT_ID
Columns
Name Datatype Length Mandatory Comments
RETAIL_PRICE_POINT_ID NUMBER
Yes Unique Identifier
OBJECT_VERSION_NUMBER NUMBER (9)
Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER (15) Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
CUST_ACCOUNT_ID NUMBER

Customer Account Identifier
SITE_USE_ID NUMBER

Site Use Identifier
SITE_USE_CODE VARCHAR2 (30)
Site Use code
INVENTORY_ITEM_ID NUMBER
Yes Inventory Item Identifier
FROM_DATE DATE

Start date of the retial price
TO_DATE DATE

End Date of the retail price
RETAIL_PRICE NUMBER

Retail Price
RETAIL_UOM_CODE VARCHAR2 (3)
Unit of measure
FACING NUMBER

Facing value
ROOT_RETAIL_PRICE_POINT_ID NUMBER

Root Retail Price Point Indentifier
REVISION NUMBER

Revison of the retail price
HISTORY_FLAG VARCHAR2 (1)
Indicates history record
ORGANIZATION_ID NUMBER

Organization Identifier
PROMOTIONAL_PRICE NUMBER

Promotional Price Attribute
DISPLAYS NUMBER

Displays
FEATURE VARCHAR2 (30)
Feature
AUDITED_DATE DATE
Yes Audited Date
CHR_ATTRIBUTE1 VARCHAR2 (30)
Char Attribute 1
CHR_ATTRIBUTE2 VARCHAR2 (30)
CHAR ATTRIBUTE 2
CHR_ATTRIBUTE3 VARCHAR2 (30)
CHAR ATTRIBUTE3
CHR_ATTRIBUTE4 VARCHAR2 (30)
CHAR ATTRIBUTE4
CHR_ATTRIBUTE5 VARCHAR2 (240)
CHAR ATTRIBUTE5
CHR_ATTRIBUTE6 VARCHAR2 (30)
CHAR ATTRIBUTE6
CHR_ATTRIBUTE7 VARCHAR2 (30)
CHAR ATTRIBUTE7
CHR_ATTRIBUTE8 VARCHAR2 (30)
CHAR ATTRIBUTE8
CHR_ATTRIBUTE9 VARCHAR2 (30)
CHAR ATTRIBUTE9
CHR_ATTRIBUTE10 VARCHAR2 (30)
CHAR ATTRIBUTE10
CHR_ATTRIBUTE11 VARCHAR2 (30)
CHAR ATTRIBUTE11
CHR_ATTRIBUTE12 VARCHAR2 (30)
CHAR ATTRIBUTE12
CHR_ATTRIBUTE13 VARCHAR2 (30)
CHAR ATTRIBUTE13
CHR_ATTRIBUTE14 VARCHAR2 (30)
CHAR ATTRIBUTE14
CHR_ATTRIBUTE15 VARCHAR2 (30)
CHAR ATTRIBUTE15
NUM_ATTRIBUTE1 NUMBER (15)
NUM ATTRIBUTE1
NUM_ATTRIBUTE2 NUMBER (15)
NUM ATTRIBUTE2
NUM_ATTRIBUTE3 NUMBER (15)
NUM ATTRIBUTE3
NUM_ATTRIBUTE5 NUMBER (15)
NUM ATTRIBUTE5
NUM_ATTRIBUTE4 NUMBER (15)
NUM ATTRIBUTE4
NUM_ATTRIBUTE6 NUMBER (15)
NUM ATTRIBUTE6
NUM_ATTRIBUTE7 NUMBER (15)
NUM_ATTRIBUTE7
NUM_ATTRIBUTE8 NUMBER (15)
NUM ATTRIBUTE8
NUM_ATTRIBUTE9 NUMBER (15)
NUM ATTRIBUTE9
NUM_ATTRIBUTE10 NUMBER (15)
NUM ATTRIBUTE10
NUM_ATTRIBUTE11 NUMBER (15)
NUM ATTRIBUTE11
NUM_ATTRIBUTE12 NUMBER (15)
NUM ATTRIBUTE12
NUM_ATTRIBUTE13 NUMBER (15)
NUM ATTRIBUTE13
NUM_ATTRIBUTE14 NUMBER (15)
NUM ATTRIBUTE14
NUM_ATTRIBUTE15 NUMBER (15)
NUM ATTRIBUTE15
Query Text

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


SELECT RETAIL_PRICE_POINT_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUST_ACCOUNT_ID
,      SITE_USE_ID
,      SITE_USE_CODE
,      INVENTORY_ITEM_ID
,      FROM_DATE
,      TO_DATE
,      RETAIL_PRICE
,      RETAIL_UOM_CODE
,      FACING
,      ROOT_RETAIL_PRICE_POINT_ID
,      REVISION
,      HISTORY_FLAG
,      ORGANIZATION_ID
,      PROMOTIONAL_PRICE
,      DISPLAYS
,      FEATURE
,      AUDITED_DATE
,      CHR_ATTRIBUTE1
,      CHR_ATTRIBUTE2
,      CHR_ATTRIBUTE3
,      CHR_ATTRIBUTE4
,      CHR_ATTRIBUTE5
,      CHR_ATTRIBUTE6
,      CHR_ATTRIBUTE7
,      CHR_ATTRIBUTE8
,      CHR_ATTRIBUTE9
,      CHR_ATTRIBUTE10
,      CHR_ATTRIBUTE11
,      CHR_ATTRIBUTE12
,      CHR_ATTRIBUTE13
,      CHR_ATTRIBUTE14
,      CHR_ATTRIBUTE15
,      NUM_ATTRIBUTE1
,      NUM_ATTRIBUTE2
,      NUM_ATTRIBUTE3
,      NUM_ATTRIBUTE5
,      NUM_ATTRIBUTE4
,      NUM_ATTRIBUTE6
,      NUM_ATTRIBUTE7
,      NUM_ATTRIBUTE8
,      NUM_ATTRIBUTE9
,      NUM_ATTRIBUTE10
,      NUM_ATTRIBUTE11
,      NUM_ATTRIBUTE12
,      NUM_ATTRIBUTE13
,      NUM_ATTRIBUTE14
,      NUM_ATTRIBUTE15
FROM OZF.OZF_RETAIL_PRICE_POINTS;

Dependencies

[top of page]

OZF.OZF_RETAIL_PRICE_POINTS does not reference any database object

OZF.OZF_RETAIL_PRICE_POINTS is referenced by following:

SchemaOZF
ViewOZF_RETAIL_PRICE_POINTS#