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: QPR.QPR_PN_LINES

Object Details

Object Name:	QPR_PN_LINES
Object Type:	TABLE
Owner:	QPR
Subobject Name:
Status:	VALID

This table stores the details about the deal line.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_PN_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PN_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PN_LINE_ID	NUMBER		Yes	Unique Identifier of the deal line
RESPONSE_HEADER_ID	NUMBER		Yes	Unique Identifier of the response to which the line belongs.
REQUEST_HEADER_ID	NUMBER		Yes	Unique Identifier of the deal request to which a response and hence the line belongs.
PARENT_PN_LINE_ID	NUMBER			Contains the pn_line_id of the deal line which is the top model/parent of the given line.
PRICE_PLAN_ID	NUMBER			Unique Identifier to indicate the datamart from which the deal line fetches historical values like cost and offinvoice adjustment.
SOURCE_ID	NUMBER			Identifier of the deal line source.
SOURCE_REF_HDR_ID	NUMBER			Header Id to which the deal line belongs in the source instance from which it is sourced.
SOURCE_REF_LINE_ID	NUMBER			Identifier of the deal line as in the source instance from which it is sourced.
SOURCE_REQUEST_LINE_NUMBER	VARCHAR2	(30)		The ui line number of a deal line as displayed in the source instance
ORG_ID	NUMBER			Organization Identifier
ORG_DIM_SK	VARCHAR2	(240)		Surrogate Key for Organization dimension dervied from Org_id. This is used to identify an organization dimension member in the datamart.
INVENTORY_ITEM_ID	NUMBER			Inventory Item Identifier
PRODUCT_DIM_SK	VARCHAR2	(240)		Surrogate Key for Product dimension dervied from Inventory_item_id. This is used to identify a product dimension member in the datamart.
GEOGRAPHY_ID	NUMBER			Geography Identifier
GEOGRAPHY_SK	VARCHAR2	(240)		Surrogate Key for Geography dimension dervied from Grography_id. This is used to identify a geography dimension member in the datamart.
VOL_BAND_SK	VARCHAR2	(240)		Identifies the volume band in which a given deal line falls based on the transformation group defined.
PR_SEGMENT_ID	NUMBER			Pricing Segment
PR_SEGMENT_SK	VARCHAR2	(240)		Surrogate Key for Pricing Segment dimension dervied from pr_segment_id. This is used to identify a pricing segment dimension member in the datamart.
PAYMENT_TERM_ID	NUMBER			Identifier of the deal line payment term. If a what-if is done, this may differ from the payment term proposed in the source instance.
SHIP_METHOD_CODE	VARCHAR2	(240)		Identifier of the deal line shipping method. If a what-if is done, this may differ from the ship method proposed in the source instance.
UOM_CODE	VARCHAR2	(240)		Unit of Measure for the deal line quantities.
CURRENCY_CODE	VARCHAR2	(240)		Currency of the deal line prices.
ITEM_TYPE_CODE	VARCHAR2	(240)		Identifies the item type. E.g. STANDARD, MODEL
ORDERED_QTY	NUMBER			The original quantity ordered against the deal line in the source instance.
REVISED_OQ	NUMBER			The modified quantity of the deal line during a what-if.
PROPOSED_PRICE	NUMBER			Invoice Price of the deal line as proposed in the source instance.
RECOMMENDED_PRICE	NUMBER			The recommended Invoice price of the deal line, obtained from regressional analysis of the historical data.
COMPETITOR_PRICE	NUMBER			Competitor Price
COMPETITOR_NAME	VARCHAR2	(240)		Competitor Name
LINE_PRICING_SCORE	NUMBER			Score assigned to a deal line after applying the deal scoring algorithm based on margin and invoice price.
REGRESSION_SLOPE	NUMBER			Slope component for the deal line after the regression analysis
REGRESSION_INTERCEPT	NUMBER			Intercept component of the deal line after the regression analysis
DATAMART_NAME	VARCHAR2	(240)		Name of the datamart from which the historical data is fetched
ORG_LONG_DESC	VARCHAR2	(240)		Organization Long Description
ORG_SHORT_DESC	VARCHAR2	(240)		Organization Short Description
INVENTORY_ITEM_SHORT_DESC	VARCHAR2	(240)		Inventory Short Description
INVENTORY_ITEM_LONG_DESC	VARCHAR2	(240)		Inventory Long Description
GEOGRAPHY_SHORT_DESC	VARCHAR2	(240)		Geography Short Description
GEOGRAPHY_LONG_DESC	VARCHAR2	(240)		Geography Long Description
PAYMENT_TERM_SHORT_DESC	VARCHAR2	(240)		Payment Short Description
PAYMENT_TERM_LONG_DESC	VARCHAR2	(240)		Payment Long Description
CURRENCY_SHORT_DESC	VARCHAR2	(240)		Currency Short Description
UOM_SHORT_DESC	VARCHAR2	(240)		UOM Short Description
SHIP_METHOD_SHORT_DESC	VARCHAR2	(240)		Shipping method short description
SHIP_METHOD_LONG_DESC	VARCHAR2	(240)		Shipping method Long description
ORIG_PAYMENT_TERM_ID	NUMBER			Payment Term of the line as proposed in the source instance.
ORIG_SHIP_METHOD_CODE	VARCHAR2	(240)		Ship method code of the deal line as proposed in the source instance.
COMMENTS	VARCHAR2	(2000)		Comments
ADDITIONAL_INFORMATION	VARCHAR2	(2000)		Column to store additional details about the deal line.
MEASURE1_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE2_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE3_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE4_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE5_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE6_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE7_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE8_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE9_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE10_NUMBER	NUMBER			Generic Column to source additional numeric values from source instance, if required.
MEASURE1_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE2_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE3_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE4_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE5_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE6_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE7_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE8_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE9_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
MEASURE10_CHAR	VARCHAR2	(240)		Generic Column to source additional string values from source instance, if required.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Identifies the concurrent program
PROGRAM_LOGIN_ID	NUMBER			Identifies the Oracle Applicaitons Concurrent Program Login ID
PROGRAM_APPLICATION_ID	NUMBER			Identifies the Oracle Application that spawned the concurrent program
REQUEST_ID	NUMBER			Identifies the concurrent request instance that spawned the concurrent program

Query Text

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


SELECT PN_LINE_ID
,      RESPONSE_HEADER_ID
,      REQUEST_HEADER_ID
,      PARENT_PN_LINE_ID
,      PRICE_PLAN_ID
,      SOURCE_ID
,      SOURCE_REF_HDR_ID
,      SOURCE_REF_LINE_ID
,      SOURCE_REQUEST_LINE_NUMBER
,      ORG_ID
,      ORG_DIM_SK
,      INVENTORY_ITEM_ID
,      PRODUCT_DIM_SK
,      GEOGRAPHY_ID
,      GEOGRAPHY_SK
,      VOL_BAND_SK
,      PR_SEGMENT_ID
,      PR_SEGMENT_SK
,      PAYMENT_TERM_ID
,      SHIP_METHOD_CODE
,      UOM_CODE
,      CURRENCY_CODE
,      ITEM_TYPE_CODE
,      ORDERED_QTY
,      REVISED_OQ
,      PROPOSED_PRICE
,      RECOMMENDED_PRICE
,      COMPETITOR_PRICE
,      COMPETITOR_NAME
,      LINE_PRICING_SCORE
,      REGRESSION_SLOPE
,      REGRESSION_INTERCEPT
,      DATAMART_NAME
,      ORG_LONG_DESC
,      ORG_SHORT_DESC
,      INVENTORY_ITEM_SHORT_DESC
,      INVENTORY_ITEM_LONG_DESC
,      GEOGRAPHY_SHORT_DESC
,      GEOGRAPHY_LONG_DESC
,      PAYMENT_TERM_SHORT_DESC
,      PAYMENT_TERM_LONG_DESC
,      CURRENCY_SHORT_DESC
,      UOM_SHORT_DESC
,      SHIP_METHOD_SHORT_DESC
,      SHIP_METHOD_LONG_DESC
,      ORIG_PAYMENT_TERM_ID
,      ORIG_SHIP_METHOD_CODE
,      COMMENTS
,      ADDITIONAL_INFORMATION
,      MEASURE1_NUMBER
,      MEASURE2_NUMBER
,      MEASURE3_NUMBER
,      MEASURE4_NUMBER
,      MEASURE5_NUMBER
,      MEASURE6_NUMBER
,      MEASURE7_NUMBER
,      MEASURE8_NUMBER
,      MEASURE9_NUMBER
,      MEASURE10_NUMBER
,      MEASURE1_CHAR
,      MEASURE2_CHAR
,      MEASURE3_CHAR
,      MEASURE4_CHAR
,      MEASURE5_CHAR
,      MEASURE6_CHAR
,      MEASURE7_CHAR
,      MEASURE8_CHAR
,      MEASURE9_CHAR
,      MEASURE10_CHAR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM QPR.QPR_PN_LINES;

Dependencies

[top of page]

QPR.QPR_PN_LINES does not reference any database object

QPR.QPR_PN_LINES is referenced by following:

APPS: QPR_PN_LINES