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_INT_HEADERS#

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
PN_INT_HEADER_ID	NUMBER		Yes
SOURCE_ID	NUMBER
SOURCE_REF_HEADER_ID	NUMBER
INSTANCE_ID	NUMBER		Yes
PN_REQ_HEADER_CREATION_DATE	DATE
PN_REQ_EXPIRY_DATE	DATE
PN_REQ_HEADER_STATUS_FLAG	VARCHAR2	(1)
CUSTOMER_ID	NUMBER
SALES_REP_ID	NUMBER
INVOICE_TO_PARTY_SITE_ID	NUMBER
SALES_CHANNEL_CODE	VARCHAR2	(240)
FREIGHT_TERMS_CODE	VARCHAR2	(240)
CURRENCY_CODE	VARCHAR2	(240)
SOURCE_LONG_DESC	VARCHAR2	(240)
SOURCE_REF_HEADER_SHORT_DESC	VARCHAR2	(240)
SOURCE_SHORT_DESC	VARCHAR2	(240)
SOURCE_REF_HEADER_LONG_DESC	VARCHAR2	(240)
CUSTOMER_SHORT_DESC	VARCHAR2	(240)
CUSTOMER_LONG_DESC	VARCHAR2	(240)
INVOICE_TO_PARTY_SITE_ADDRESS	VARCHAR2	(4000)
SALES_REP_SHORT_DESC	VARCHAR2	(240)
SALES_REP_LONG_DESC	VARCHAR2	(240)
SALES_REP_EMAIL_ADDRESS	VARCHAR2	(240)
SALES_CHANNEL_SHORT_DESC	VARCHAR2	(240)
SALES_CHANNEL_LONG_DESC	VARCHAR2	(240)
FREIGHT_TERMS_SHORT_DESC	VARCHAR2	(240)
FREIGHT_TERMS_LONG_DESC	VARCHAR2	(240)
CURRENCY_SHORT_DESC	VARCHAR2	(240)
CURRENCY_LONG_DESC	VARCHAR2	(240)
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)
COMMENTS	VARCHAR2	(2000)
ADDITIONAL_INFORMATION	VARCHAR2	(2000)
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_INT_HEADER_ID
,      SOURCE_ID
,      SOURCE_REF_HEADER_ID
,      INSTANCE_ID
,      PN_REQ_HEADER_CREATION_DATE
,      PN_REQ_EXPIRY_DATE
,      PN_REQ_HEADER_STATUS_FLAG
,      CUSTOMER_ID
,      SALES_REP_ID
,      INVOICE_TO_PARTY_SITE_ID
,      SALES_CHANNEL_CODE
,      FREIGHT_TERMS_CODE
,      CURRENCY_CODE
,      SOURCE_LONG_DESC
,      SOURCE_REF_HEADER_SHORT_DESC
,      SOURCE_SHORT_DESC
,      SOURCE_REF_HEADER_LONG_DESC
,      CUSTOMER_SHORT_DESC
,      CUSTOMER_LONG_DESC
,      INVOICE_TO_PARTY_SITE_ADDRESS
,      SALES_REP_SHORT_DESC
,      SALES_REP_LONG_DESC
,      SALES_REP_EMAIL_ADDRESS
,      SALES_CHANNEL_SHORT_DESC
,      SALES_CHANNEL_LONG_DESC
,      FREIGHT_TERMS_SHORT_DESC
,      FREIGHT_TERMS_LONG_DESC
,      CURRENCY_SHORT_DESC
,      CURRENCY_LONG_DESC
,      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
,      COMMENTS
,      ADDITIONAL_INFORMATION
,      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_HEADERS#;

Dependencies

[top of page]

QPR.QPR_PN_INT_HEADERS# references the following:

QPR: QPR_PN_INT_HEADERS

QPR.QPR_PN_INT_HEADERS# is referenced by following:

APPS: QPR_PN_INT_HEADERS