[Home] [Help] [Dependency Information]
Object Name: | OTFV_PRICE_LISTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_PRICE_LISTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the price list information.
Price list contains entries that identify pricing information for activities, between two dates.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | The name of the Business Group |
PRICE_LIST_NAME | VARCHAR2 | (80) | Yes | The name of the price list |
PRICE_LIST_COMMENTS | VARCHAR2 | (2000) | Free text comments | |
DESCRIPTION | VARCHAR2 | (240) | The description of the price list | |
CURRENCY | VARCHAR2 | (4000) | The currency defined for the Price List | |
DEFAULT_PRICE_LIST | VARCHAR2 | (4000) | Indicates whether the price list is the default | |
PRICE_LIST_START_DATE | DATE | Yes | The date from which the Price List is valid | |
PRICE_LIST_END_DATE | DATE | The date until which the Price List is valid | ||
PRICE_LIST_TYPE | VARCHAR2 | (4000) | The type of Price List | |
UNIT_PRICE | NUMBER | (9) | Cost of a single unit in specified currency | |
TRAINING_UNIT | VARCHAR2 | (30) | Type of unit being specified for the Price List | |
_DF | CHAR | (27) | Descriptive Flex Fields | |
PRICE_LIST_ID | NUMBER | (9) | Yes | The system generated key for this Price List |
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | The system generated key for this Business Group |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PRICE_LIST_NAME
, PRICE_LIST_COMMENTS
, DESCRIPTION
, CURRENCY
, DEFAULT_PRICE_LIST
, PRICE_LIST_START_DATE
, PRICE_LIST_END_DATE
, PRICE_LIST_TYPE
, UNIT_PRICE
, TRAINING_UNIT
, _DF
, PRICE_LIST_ID
, BUSINESS_GROUP_ID
FROM APPS.OTFV_PRICE_LISTS;
|
|
|