DBA Data[Home] [Help] [Dependency Information]

TABLE: QP.QP_PARAMETERS_B

Object Details
Object Name: QP_PARAMETERS_B
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_PARAMETERS_B
Subobject Name:
Status: VALID


The parameters stores the information against a level . Example - Request Type .


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_PARAMETERS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARAMETER_ID
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER
Yes Identifies the parameter.System generated unique identifier
PARAMETER_LEVEL VARCHAR2 (30) Yes Not Null Parameter Level
PARAMETER_CODE VARCHAR2 (30) Yes Parameter Code
VALUE_SET_ID NUMBER

Value set that provides possible values for the parameter.
ADVANCED_PRICING_ONLY VARCHAR2 (1)
Indicates whether the parameter is only available for Advanced Pricing customer.
SEEDED_VALUE VARCHAR2 (30)
Seeded Value for the parameter
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARAMETER_ID
,      PARAMETER_LEVEL
,      PARAMETER_CODE
,      VALUE_SET_ID
,      ADVANCED_PRICING_ONLY
,      SEEDED_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM QP.QP_PARAMETERS_B;

Dependencies

[top of page]

QP.QP_PARAMETERS_B does not reference any database object

QP.QP_PARAMETERS_B is referenced by following:

SchemaQP
ViewQP_PARAMETERS_B#