eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: QP.QP_CURRENCY_DETAILS

Object Details

Object Name:	QP_CURRENCY_DETAILS
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_CURRENCY_DETAILS
Subobject Name:
Status:	VALID

QP_CURRENCY_DETAILS stores all the lines for the multi-currency lists in QP_CURRENCY_LISTS_B.
At any point of time there can be only one active record for a given to_currency_code. This
table has atleast one record of to_currency_code = base_currency_code, for each base currency
code in the QP_CURRENCY_LISTS_B table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QP_CURRENCY_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_HEADER_ID TO_CURRENCY_CODE START_DATE_ACTIVE END_DATE_ACTIVE
QP_CURRENCY_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_HEADER_ID CURR_ATTRIBUTE_VALUE CURR_ATTRIBUTE_TYPE TO_CURRENCY_CODE START_DATE_ACTIVE END_DATE_ACTIVE

Columns

Name	Datatype	Length	Mandatory	Comments
CURRENCY_HEADER_ID	NUMBER		Yes	References primary key of QP_CURRENCY_LISTS_B
CURRENCY_DETAIL_ID	NUMBER		Yes	Primary key of QP_CURRENCY_DETAILS. System generated ID
TO_CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency code to be used for conversion
START_DATE_ACTIVE	DATE			Effective start date of the record
END_DATE_ACTIVE	DATE			Effective end date of the record
FIXED_VALUE	NUMBER			Constant conversion value for lines of 'FIXED' conversion_type
PRICE_FORMULA_ID	NUMBER			References primary key of QP_PRICE_FORMULAS_B for lines of 'FORMULA' conversion_type. The formula can not have a line component of type 'PLL'.
CONVERSION_TYPE	VARCHAR2	(30)		Identifies the conversion method to be used for conversion. Possible values are 'FIXED', 'FORMULA', 'TRANSACTION', and all the conversion types defined in GL_DAILY_CONVERSION_TYPES other than 'User'
CONVERSION_DATE_TYPE	VARCHAR2	(30)		Conversion Date Type for lines having conversion_type other than 'FIXED', 'FORMULA', and 'TRANSACTION'
CONVERSION_DATE	DATE			Conversion Date is required for lines having 'FIXED' conversion_date_type
ROUNDING_FACTOR	NUMBER			Rounding factor used for rounding the conversion
MARKUP_OPERATOR	VARCHAR2	(30)		Markup Operator will be applied to either markup value or Markup formula, whichever is entered. It can be either % or AMT
MARKUP_VALUE	NUMBER			Numeric constant value of the markup. Markup_Value, Markup_Formula_id or both should be present if the markup_opearator is not NULL
MARKUP_FORMULA_ID	NUMBER			References primary key of QP_PRICE_FORMULAS_B. The formula can not have a line component of type 'PLL'. Markup_Value, Markup_Formula_id or both should be present if the markup_opearator is not NULL
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
REQUEST_ID	NUMBER			Standard WHO Column
PROGRAM_APPLICATION_ID	NUMBER			Standard WHO Column
PROGRAM_ID	NUMBER			Standard WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard WHO Column
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
CURR_ATTRIBUTE_TYPE	VARCHAR2	(30)		The attribute type of the multi-currency detail record. It could be either PRODUCT, PRICING or QUALIFIER.
CURR_ATTRIBUTE_CONTEXT	VARCHAR2	(30)		The attribute context with respect to the curr_attribute_type. For example, if curr_attribute_type is 'PRODUCT', this could be 'ITEM'.
CURR_ATTRIBUTE	VARCHAR2	(30)		The attribute code with respect to the curr_attribute_context. For example, if the curr_attribute_context is ITEM, this could be PRICING_ATTRIBUTE1 for inventory item.
CURR_ATTRIBUTE_VALUE	VARCHAR2	(240)		The attribute value with respect to curr_attribute. For example if the curr_attribute is 'PRICING_ATTRIBUTE1', this will contain a valid inventory_item_id.
PRECEDENCE	NUMBER			Precedence of the currency detail record for a given to_currency_code. It should be a unique positive integer for a to_currency_code and effective dates. It is required when curr_attribute_type is provided. It is used by pricing engine to select a detail record when more than one records are selected. Lower number get higher precedence.
SELLING_ROUNDING_FACTOR	NUMBER			The rounding factor to be applied on the selling price.

Query Text

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


SELECT CURRENCY_HEADER_ID
,      CURRENCY_DETAIL_ID
,      TO_CURRENCY_CODE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      FIXED_VALUE
,      PRICE_FORMULA_ID
,      CONVERSION_TYPE
,      CONVERSION_DATE_TYPE
,      CONVERSION_DATE
,      ROUNDING_FACTOR
,      MARKUP_OPERATOR
,      MARKUP_VALUE
,      MARKUP_FORMULA_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CURR_ATTRIBUTE_TYPE
,      CURR_ATTRIBUTE_CONTEXT
,      CURR_ATTRIBUTE
,      CURR_ATTRIBUTE_VALUE
,      PRECEDENCE
,      SELLING_ROUNDING_FACTOR
FROM QP.QP_CURRENCY_DETAILS;

Dependencies

[top of page]

QP.QP_CURRENCY_DETAILS does not reference any database object

QP.QP_CURRENCY_DETAILS is referenced by following:

APPS: QP_CURRENCY_DETAILS