[Home] [Help] [Dependency Information]
Object Name: | OZF_NA_PRODUCTS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | OZF |
FND Design Data: | OZF.OZF_NA_PRODUCTS_TEMP |
Subobject Name: | |
Status: | VALID |
Table to store the products eligible for a Net Accrual Offer
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
PRODUCT_LEVEL | VARCHAR2 | (30) | Yes | Product Level |
DISCOUNT | NUMBER | Yes | Discount | |
DISCOUNT_TYPE | VARCHAR2 | (30) | Yes | Discount Type |
VOLUME_FROM | NUMBER | Volume From | ||
VOLUME_TO | NUMBER | Volume To | ||
VOLUME_TYPE | VARCHAR2 | (30) | Volume Type | |
UOM | VARCHAR2 | (3) | Uom |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, PRODUCT_LEVEL
, DISCOUNT
, DISCOUNT_TYPE
, VOLUME_FROM
, VOLUME_TO
, VOLUME_TYPE
, UOM
FROM OZF.OZF_NA_PRODUCTS_TEMP;
OZF.OZF_NA_PRODUCTS_TEMP does not reference any database object
OZF.OZF_NA_PRODUCTS_TEMP is referenced by following:
|
|
|