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

TABLE: OZF.OZF_WORKSHEET_LINES

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


Table to store the Worksheet Discount lines


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_WORKSHEET_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKSHEET_LINE_ID
OZF_WORKSHEET_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnWORKSHEET_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
WORKSHEET_LINE_ID NUMBER
Yes Unique Identifier
CREATION_DATE DATE
Yes Standard WHO Column
CREATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_DATE DATE
Yes Standard WHO Column
LAST_UPDATED_BY NUMBER
Yes Standard WHO Column
LAST_UPDATE_LOGIN NUMBER

Standard WHO Column
OBJECT_VERSION_NUMBER NUMBER

Standard WHO Column
WORKSHEET_HEADER_ID NUMBER
Yes Worksheet Header Identifier
PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2 (30)
Product Attribute Context
PRODUCT_ATTRIBUTE VARCHAR2 (30)
Product Attribute
PRODUCT_ATTR_VALUE VARCHAR2 (240)
Product Attribute Value
PRODUCT_UOM_CODE VARCHAR2 (3)
Unit Of Measure
ARITHMETIC_OPERATOR VARCHAR2 (30)
Arithmetic Operator
OPERAND NUMBER

Operand
OTHER_COSTS NUMBER

Other costs
FORECASTED_UNITS NUMBER

Forecasted units
OFFER_TYPE VARCHAR2 (30)
Offer type
LIST_PRICE NUMBER

List Price Identifier
ITEM_COST NUMBER

Cost of Item
QUANTITY NUMBER

Quantity for Scan Data
SCAN_TYPE NUMBER

Scan Type
SCAN_VALUE NUMBER

Scan Value
SCAN_UNIT_FORECAST NUMBER

Scan Unit Forecast
DISTRIBUTION_VALUE NUMBER

Distribution Value
MIN_ORDER_VALUE NUMBER

Min Order Value
MAX_ORDER_VALUE NUMBER

Max Order Value
MAX_UNITS_PER_ORDER NUMBER

Max Units per Order
MAX_ORDERS_PER_CUSTOMER NUMBER

Max Orders per Customer
MAX_UNITS_PER_RULE NUMBER

Max Units Per Rule
MAX_COMMITTED_AMT_PER_RULE NUMBER

Max Committed Amount per rule
PARENT_WORKSHEET_LINE_ID NUMBER

Parent Worksheet Line Id
RETAIL_UOM_CODE VARCHAR2 (3)
Retail Uom Code
DESIRED_RETAIL_PRICE NUMBER

Desired Retail Price
RETAILERS_MARGIN NUMBER

Retailers Margin
ADJUST_BUDGET VARCHAR2 (1)
Adjust Budget
UOM_CODE VARCHAR2 (3)
Uom Code
EXCLUDE_FLAG VARCHAR2 (1)
Exclude Flag
PRODUCT_CONCAT_VALUE VARCHAR2 (240)
Product Concat Value
Query Text

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


SELECT WORKSHEET_LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      WORKSHEET_HEADER_ID
,      PRODUCT_ATTRIBUTE_CONTEXT
,      PRODUCT_ATTRIBUTE
,      PRODUCT_ATTR_VALUE
,      PRODUCT_UOM_CODE
,      ARITHMETIC_OPERATOR
,      OPERAND
,      OTHER_COSTS
,      FORECASTED_UNITS
,      OFFER_TYPE
,      LIST_PRICE
,      ITEM_COST
,      QUANTITY
,      SCAN_TYPE
,      SCAN_VALUE
,      SCAN_UNIT_FORECAST
,      DISTRIBUTION_VALUE
,      MIN_ORDER_VALUE
,      MAX_ORDER_VALUE
,      MAX_UNITS_PER_ORDER
,      MAX_ORDERS_PER_CUSTOMER
,      MAX_UNITS_PER_RULE
,      MAX_COMMITTED_AMT_PER_RULE
,      PARENT_WORKSHEET_LINE_ID
,      RETAIL_UOM_CODE
,      DESIRED_RETAIL_PRICE
,      RETAILERS_MARGIN
,      ADJUST_BUDGET
,      UOM_CODE
,      EXCLUDE_FLAG
,      PRODUCT_CONCAT_VALUE
FROM OZF.OZF_WORKSHEET_LINES;

Dependencies

[top of page]

OZF.OZF_WORKSHEET_LINES does not reference any database object

OZF.OZF_WORKSHEET_LINES is referenced by following:

SchemaOZF
ViewOZF_WORKSHEET_LINES#