[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_PRICE_PARMS |
---|---|
Object Type: | TABLE |
Owner: | OKL |
FND Design Data: | OKL.OKL_SIF_PRICE_PARMS |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OKL_SPP_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING | ID |
OKL_SPP_U2 | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
NAME
VERSION |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
DESCRIPTION | VARCHAR2 | (1995) | User entered description | |
DATE_START | DATE | Yes | Effective start date for a parameter. | |
DATE_END | DATE | Effective end date for a parameter. | ||
SPS_CODE | VARCHAR2 | (30) | Yes | Lookup code for contract or asset level. Valid values are ASSET and CONTRACT. |
ARRAY_YN | VARCHAR2 | (30) | Yes | Yes or No |
DYP_CODE | VARCHAR2 | (30) | Yes | Lookup code for data type of the parameter. Valid values are DATE, NUMBER and STRING. |
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 ID
, OBJECT_VERSION_NUMBER
, NAME
, VERSION
, DESCRIPTION
, DATE_START
, DATE_END
, SPS_CODE
, ARRAY_YN
, DYP_CODE
, 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 OKL.OKL_SIF_PRICE_PARMS;
OKL.OKL_SIF_PRICE_PARMS does not reference any database object
OKL.OKL_SIF_PRICE_PARMS is referenced by following:
|
|
|