[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_PRICE_PARMS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_SIF_PRICE_PARMS_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Apart from the parameters which are captured during the booking process certain custom
parameters can be defined for the external pricing process. The details of such parameters like
name, start date, end date etc. are stored here.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Auto-generated by Headstart Utilities | |
ID | NUMBER | Yes | Primary key column | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Column used for locking records during updates |
NAME | VARCHAR2 | (150) | Yes | Line number |
VERSION | VARCHAR2 | (24) | Yes | Version |
DATE_START | DATE | Yes | Effective start date for a parameter. | |
DATE_END | DATE | Effective end date for a parameter. | ||
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
SPS_CODE | VARCHAR2 | (30) | Yes | Lookup code for contract or asset level. Valid values are ASSET and CONTRACT. |
DYP_CODE | VARCHAR2 | (30) | Yes | Lookup code for data type of the parameter. Valid values are DATE, NUMBER and STRING. |
ARRAY_YN | VARCHAR2 | (30) | Yes | Yes or No |
XML_TAG | VARCHAR2 | (120) | For future use. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | Descriptive flexfield category column | |
ATTRIBUTE1 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (450) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (450) | Descriptive flexfield column | |
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_LOGIN | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ID
, OBJECT_VERSION_NUMBER
, NAME
, VERSION
, DATE_START
, DATE_END
, DESCRIPTION
, SPS_CODE
, DYP_CODE
, ARRAY_YN
, XML_TAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM APPS.OKL_SIF_PRICE_PARMS_V;
|
|
|