[Home] [Help] [Dependency Information]
Object Name: | OKL_PRD_PRICE_TMPLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_PRD_PRICE_TMPLS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Various attributes of pricing templates like name, start date, description etc. are stored here. Each
of these templates is attached to a particular product and is used for external pricing. The reference
of the product to which a template belongs is also
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
VERSION | VARCHAR2 | (24) | Yes | Version |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
PDT_ID | NUMBER | Yes | Foreign key to table OKL_PRODUCTS | |
TEMPLATE_NAME | VARCHAR2 | (150) | Yes | User entered name of the pricing template. |
START_DATE | DATE | Yes | Start date | |
END_DATE | DATE | End date | ||
TEMPLATE_PATH | VARCHAR2 | (400) | User entered directory path of the pricing template. The external pricing engine looks for a pricing template at this location. | |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
CREATION_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, VERSION
, OBJECT_VERSION_NUMBER
, PDT_ID
, TEMPLATE_NAME
, START_DATE
, END_DATE
, TEMPLATE_PATH
, DESCRIPTION
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_PRD_PRICE_TMPLS_V;
|
|
|