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]

VIEW: QPR.QPR_PN_LINES#

Object Details

Object Name:	QPR_PN_LINES#
Object Type:	VIEW
Owner:	QPR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PN_LINE_ID	NUMBER		Yes
RESPONSE_HEADER_ID	NUMBER		Yes
REQUEST_HEADER_ID	NUMBER		Yes
PARENT_PN_LINE_ID	NUMBER
PRICE_PLAN_ID	NUMBER
SOURCE_ID	NUMBER
SOURCE_REF_HDR_ID	NUMBER
SOURCE_REF_LINE_ID	NUMBER
SOURCE_REQUEST_LINE_NUMBER	VARCHAR2	(30)
ORG_ID	NUMBER
ORG_DIM_SK	VARCHAR2	(240)
INVENTORY_ITEM_ID	NUMBER
PRODUCT_DIM_SK	VARCHAR2	(240)
GEOGRAPHY_ID	NUMBER
GEOGRAPHY_SK	VARCHAR2	(240)
VOL_BAND_SK	VARCHAR2	(240)
PR_SEGMENT_ID	NUMBER
PR_SEGMENT_SK	VARCHAR2	(240)
PAYMENT_TERM_ID	NUMBER
SHIP_METHOD_CODE	VARCHAR2	(240)
UOM_CODE	VARCHAR2	(240)
CURRENCY_CODE	VARCHAR2	(240)
ITEM_TYPE_CODE	VARCHAR2	(240)
ORDERED_QTY	NUMBER
REVISED_OQ	NUMBER
PROPOSED_PRICE	NUMBER
RECOMMENDED_PRICE	NUMBER
COMPETITOR_PRICE	NUMBER
COMPETITOR_NAME	VARCHAR2	(240)
LINE_PRICING_SCORE	NUMBER
REGRESSION_SLOPE	NUMBER
REGRESSION_INTERCEPT	NUMBER
DATAMART_NAME	VARCHAR2	(240)
ORG_LONG_DESC	VARCHAR2	(240)
ORG_SHORT_DESC	VARCHAR2	(240)
INVENTORY_ITEM_SHORT_DESC	VARCHAR2	(240)
INVENTORY_ITEM_LONG_DESC	VARCHAR2	(240)
GEOGRAPHY_SHORT_DESC	VARCHAR2	(240)
GEOGRAPHY_LONG_DESC	VARCHAR2	(240)
PAYMENT_TERM_SHORT_DESC	VARCHAR2	(240)
PAYMENT_TERM_LONG_DESC	VARCHAR2	(240)
CURRENCY_SHORT_DESC	VARCHAR2	(240)
UOM_SHORT_DESC	VARCHAR2	(240)
SHIP_METHOD_SHORT_DESC	VARCHAR2	(240)
SHIP_METHOD_LONG_DESC	VARCHAR2	(240)
ORIG_PAYMENT_TERM_ID	NUMBER
ORIG_SHIP_METHOD_CODE	VARCHAR2	(240)
COMMENTS	VARCHAR2	(2000)
ADDITIONAL_INFORMATION	VARCHAR2	(2000)
MEASURE1_NUMBER	NUMBER
MEASURE2_NUMBER	NUMBER
MEASURE3_NUMBER	NUMBER
MEASURE4_NUMBER	NUMBER
MEASURE5_NUMBER	NUMBER
MEASURE6_NUMBER	NUMBER
MEASURE7_NUMBER	NUMBER
MEASURE8_NUMBER	NUMBER
MEASURE9_NUMBER	NUMBER
MEASURE10_NUMBER	NUMBER
MEASURE1_CHAR	VARCHAR2	(240)
MEASURE2_CHAR	VARCHAR2	(240)
MEASURE3_CHAR	VARCHAR2	(240)
MEASURE4_CHAR	VARCHAR2	(240)
MEASURE5_CHAR	VARCHAR2	(240)
MEASURE6_CHAR	VARCHAR2	(240)
MEASURE7_CHAR	VARCHAR2	(240)
MEASURE8_CHAR	VARCHAR2	(240)
MEASURE9_CHAR	VARCHAR2	(240)
MEASURE10_CHAR	VARCHAR2	(240)
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_LOGIN_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
REQUEST_ID	NUMBER

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# references the following:

QPR: QPR_PN_LINES

QPR.QPR_PN_LINES# is referenced by following:

APPS: QPR_PN_LINES