[Home] [Help] [Dependency Information]
Object Name: | PV_REFERRED_PRODUCTS |
---|---|
Object Type: | TABLE |
Owner: | PV |
FND Design Data: | PV.PV_REFERRED_PRODUCTS |
Subobject Name: | |
Status: | VALID |
This table stores the product categories used by the referral. The product categories selected here are restricted to the product categories and their children in the product hierarchy specified in the benefit to which this referral is created from. The benefit's product categories are stored in pv_benft_products.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PV_REFERRED_PRODUCTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REFERRAL_ID |
PV_REFERRED_PRODUCTS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | REFERRED_PRODUCT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REFERRED_PRODUCT_ID | NUMBER | Yes | Referred products identifier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number | |
QUANTITY | NUMBER | Quantity | ||
AMOUNT | NUMBER | Amount | ||
REFERRAL_ID | NUMBER | Yes | Referral identifier | |
SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
PRODUCT_CATEGORY_ID | NUMBER | Yes | Product category identifier | |
PRODUCT_CATEGORY_SET_ID | NUMBER | Yes | Product category set identifier | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment column | |
ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT REFERRED_PRODUCT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, QUANTITY
, AMOUNT
, REFERRAL_ID
, SECURITY_GROUP_ID
, PRODUCT_CATEGORY_ID
, PRODUCT_CATEGORY_SET_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
FROM PV.PV_REFERRED_PRODUCTS;
PV.PV_REFERRED_PRODUCTS does not reference any database object
PV.PV_REFERRED_PRODUCTS is referenced by following:
|
|
|