[Home] [Help] [Dependency Information]
Object Name: | OKL_PTL_PTQ_VALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_PTL_PTQ_VALS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
DEFINITION
Holds the association of Template Qualities and Values with Product Template.For example for a Product template named Lease there could be template quality named intrested method with eighter simple or compound intrest as there values.
EXAMPLE
Product Template Template Quality Value
OP Lease Asset Category All
Interest Method Simple
Compound
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row Identifier in the database | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
PTV_ID | NUMBER | Yes | Foreign key to table OKL_PTQ_VALUES | |
PTL_ID | NUMBER | Yes | Foreign key to table OKL_PDT_TEMPLATES | |
PTQ_ID | NUMBER | Yes | Foreign key to table OKL_PTL_QUALITYS | |
FROM_DATE | DATE | Yes | From date | |
TO_DATE | DATE | To date | ||
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
, OBJECT_VERSION_NUMBER
, PTV_ID
, PTL_ID
, PTQ_ID
, FROM_DATE
, TO_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKL_PTL_PTQ_VALS_V;
|
|
|