[Home] [Help] [Dependency Information]
Object Name: | FTE_PRC_PARAMETER_DEFAULTS |
---|---|
Object Type: | TABLE |
Owner: | FTE |
FND Design Data: | FTE.FTE_PRC_PARAMETER_DEFAULTS |
Subobject Name: | |
Status: | VALID |
FTE_PRC_PARAMETER_DEFAULTS stores valid parameter names and default values for parameters.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FTE_PRC_PARAMETER_DEFAULTS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | PARAMETER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PARAMETER_ID | NUMBER | Yes | Primary key | |
PARAMETER_TYPE | VARCHAR2 | (30) | Yes | Parameter type |
LANE_FUNCTION | VARCHAR2 | (30) | Yes | Lane function |
PARAMETER_SUB_TYPE | VARCHAR2 | (30) | Yes | parameter sub type |
PARAMETER_NAME | VARCHAR2 | (30) | Yes | parameter name |
PARAMETER_DATATYPE | VARCHAR2 | (30) | Yes | parameter data type |
DEFAULT_VALUE_FROM | VARCHAR2 | (240) | default low value | |
DEFAULT_VALUE_TO | VARCHAR2 | (240) | default high value | |
DEFAULT_UOM_CLASS | VARCHAR2 | (240) | default uom class | |
DEFAULT_UOM_CODE | VARCHAR2 | (240) | default uom code | |
DEFAULT_CURRENCY_CODE | VARCHAR2 | (30) | default currency | |
USER_OVERRIDE_ALLOWED | VARCHAR2 | (1) | Yes | specifies if user is allowed to override default values |
CREATION_DATE | DATE | Yes | creation date | |
CREATED_BY | NUMBER | Yes | created by | |
LAST_UPDATE_DATE | DATE | Yes | last update date | |
LAST_UPDATED_BY | NUMBER | Yes | last updated by | |
LAST_UPDATE_LOGIN | NUMBER | last update login | ||
PROGRAM_APPLICATION_ID | NUMBER | program application id | ||
PROGRAM_ID | NUMBER | program id | ||
PROGRAM_UPDATE_DATE | DATE | program update date | ||
REQUEST_ID | NUMBER | request id |
Cut, paste (and edit) the following text to query this object:
SELECT PARAMETER_ID
, PARAMETER_TYPE
, LANE_FUNCTION
, PARAMETER_SUB_TYPE
, PARAMETER_NAME
, PARAMETER_DATATYPE
, DEFAULT_VALUE_FROM
, DEFAULT_VALUE_TO
, DEFAULT_UOM_CLASS
, DEFAULT_UOM_CODE
, DEFAULT_CURRENCY_CODE
, USER_OVERRIDE_ALLOWED
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM FTE.FTE_PRC_PARAMETER_DEFAULTS;
FTE.FTE_PRC_PARAMETER_DEFAULTS does not reference any database object
FTE.FTE_PRC_PARAMETER_DEFAULTS is referenced by following:
|
|
|