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_INT_LINES

Object Details

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

This interface table captures the deal line details from source instance.The data is dumped to this table by specifying the source table/view and column mapping in qpr_measure_sources table.This data is processed and moved to core deal line table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_PN_INT_LINES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PN_INT_LINE_ID
QPR_PN_INT_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PN_REQ_LINE_STATUS_FLAG
QPR_PN_INT_LINES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE_CODE
QPR_PN_INT_LINES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TOP_MDL_SRC_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PN_INT_LINE_ID	NUMBER		Yes	Unique Identifier for the interface line
SOURCE_ID	NUMBER			Identifier of the deal line source.
SOURCE_REF_HDR_ID	NUMBER			Identifier of the header to which the deal line belongs in the source instance
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
PRICE_PLAN_ID	NUMBER			Unique Identifier to indicate the datamart from which the deal line fetches historical values like cost and offinvoice adjustment.
ORG_ID	NUMBER			Organization Identifier
INVENTORY_ITEM_ID	NUMBER			Inventory Item Identifier
GEOGRAPHY_ID	NUMBER			Geography Identifier
PAYMENT_TERM_ID	NUMBER			Payment Term identifier
PR_SEGMENT_ID	NUMBER			Pricing Segment Identifier
VOL_BAND_SK	VARCHAR2	(240)		Identifies the volume band in which a given deal line falls based on the transformation group defined.
TOP_MDL_SRC_LINE_ID	NUMBER			Source Line Identifier Of the model line to which a line belongs.
PN_REQ_LINE_STATUS_FLAG	VARCHAR2	(1)		Indicates the status of the line. Takes values 'I' and 'F'. 'I' indicates initial data for processing and 'F' indicates failure in processing.
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 original quantity ordered against the deal line in the source instance.
LIST_PRICE	NUMBER			Price List Price
PROPOSED_PRICE	NUMBER			Invoice Price of the deal line as proposed in the source instance.
COMPETITOR_PRICE	NUMBER			Competitor Price
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
COMPETITOR_NAME	VARCHAR2	(240)		Competitor Name
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_CODE	VARCHAR2	(240)		Shipping method Identifier
SHIP_METHOD_SHORT_DESC	VARCHAR2	(240)		Ship method short description
SHIP_METHOD_LONG_DESC	VARCHAR2	(240)		Ship method long description
COMMENTS	VARCHAR2	(2000)		Comments
ADDITIONAL_INFORMATION	VARCHAR2	(2000)		Additional Information
REGRESSION_SLOPE	NUMBER			Slope component of the regression analysis
REGRESSION_INTERCEPT	NUMBER			Intercept component of the regression analysis
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.
FREIGHT_CHARGES	NUMBER			Amount Charged for freight
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_INT_LINE_ID
,      SOURCE_ID
,      SOURCE_REF_HDR_ID
,      SOURCE_REF_LINE_ID
,      SOURCE_REQUEST_LINE_NUMBER
,      PRICE_PLAN_ID
,      ORG_ID
,      INVENTORY_ITEM_ID
,      GEOGRAPHY_ID
,      PAYMENT_TERM_ID
,      PR_SEGMENT_ID
,      VOL_BAND_SK
,      TOP_MDL_SRC_LINE_ID
,      PN_REQ_LINE_STATUS_FLAG
,      UOM_CODE
,      CURRENCY_CODE
,      ITEM_TYPE_CODE
,      ORDERED_QTY
,      REVISED_OQ
,      LIST_PRICE
,      PROPOSED_PRICE
,      COMPETITOR_PRICE
,      DATAMART_NAME
,      ORG_LONG_DESC
,      ORG_SHORT_DESC
,      COMPETITOR_NAME
,      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_CODE
,      SHIP_METHOD_SHORT_DESC
,      SHIP_METHOD_LONG_DESC
,      COMMENTS
,      ADDITIONAL_INFORMATION
,      REGRESSION_SLOPE
,      REGRESSION_INTERCEPT
,      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
,      FREIGHT_CHARGES
,      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_INT_LINES;

Dependencies

[top of page]

QPR.QPR_PN_INT_LINES does not reference any database object

QPR.QPR_PN_INT_LINES is referenced by following:

APPS: QPR_PN_INT_LINES