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_HEADERS

Object Details

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

This is an interface table for getting Core Data.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QPR_PN_INT_HEADERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PN_INT_HEADER_ID
QPR_PN_INT_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_REF_HEADER_ID PN_REQ_HEADER_STATUS_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
PN_INT_HEADER_ID	NUMBER		Yes	Unique Identifier for Interface Header
SOURCE_ID	NUMBER			Identifier of the deal line source.
SOURCE_REF_HEADER_ID	NUMBER			Identifier of the header to which the deal line belongs in the source instance.
INSTANCE_ID	NUMBER		Yes	Unique identifier of the application instance from which the data is sourced.
PN_REQ_HEADER_CREATION_DATE	DATE			Deal creation date as in the source instance
PN_REQ_EXPIRY_DATE	DATE			Deal Expiry Date as in the source instance
PN_REQ_HEADER_STATUS_FLAG	VARCHAR2	(1)		Header Status takes values 'I' , 'F' and 'P'. 'I' indicating initial value ready for processing, 'P' indicating successfully processed values and 'I' indicating failure in processing.
CUSTOMER_ID	NUMBER			Customer Identifier
SALES_REP_ID	NUMBER			Sales Representative Identifier
INVOICE_TO_PARTY_SITE_ID	NUMBER			Identifier for invoice-to site
SALES_CHANNEL_CODE	VARCHAR2	(240)		Sales Channel Identifier
FREIGHT_TERMS_CODE	VARCHAR2	(240)		Not Currently Used
CURRENCY_CODE	VARCHAR2	(240)		Header Currency Code
SOURCE_LONG_DESC	VARCHAR2	(240)		Long description about source instance
SOURCE_REF_HEADER_SHORT_DESC	VARCHAR2	(240)		Short Description about the source reference header
SOURCE_SHORT_DESC	VARCHAR2	(240)		Source instance name
SOURCE_REF_HEADER_LONG_DESC	VARCHAR2	(240)		Long Description about the source reference header.
CUSTOMER_SHORT_DESC	VARCHAR2	(240)		Customer Short Description
CUSTOMER_LONG_DESC	VARCHAR2	(240)		Customer Long Description
INVOICE_TO_PARTY_SITE_ADDRESS	VARCHAR2	(4000)		Site Address
SALES_REP_SHORT_DESC	VARCHAR2	(240)		Sales Representative Short Description
SALES_REP_LONG_DESC	VARCHAR2	(240)		Sales Representative Long Description
SALES_REP_EMAIL_ADDRESS	VARCHAR2	(240)		Sales Representative Email Address
SALES_CHANNEL_SHORT_DESC	VARCHAR2	(240)		Sales Channel Short Description
SALES_CHANNEL_LONG_DESC	VARCHAR2	(240)		Sales Channel Long Description
FREIGHT_TERMS_SHORT_DESC	VARCHAR2	(240)		Freight Short Description
FREIGHT_TERMS_LONG_DESC	VARCHAR2	(240)		Freight Long Description
CURRENCY_SHORT_DESC	VARCHAR2	(240)		Currency Short Description
CURRENCY_LONG_DESC	VARCHAR2	(240)		Currency Long Description
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.
COMMENTS	VARCHAR2	(2000)		Comments
ADDITIONAL_INFORMATION	VARCHAR2	(2000)		Additional Information
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_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 does not reference any database object

QPR.QPR_PN_INT_HEADERS is referenced by following:

APPS: QPR_PN_INT_HEADERS