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: APPS.PO_RFQ_HEADERS_PRINT

Object Details

Object Name:	PO_RFQ_HEADERS_PRINT
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_RFQ_HEADERS_PRINT
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RFQ_NUM	VARCHAR2	(20)	Yes	RFQ Number
REVISION_NUM	NUMBER			Document revision number
CREATION_DATE	DATE			Standard who column - date when this row was created.
PRINTED_DATE	DATE			Date the document was last printed
REVISED_DATE	DATE			Date the document was last revised
CLOSE_DATE	DATE			Document close date
REPLY_BY_DATE	DATE			Reply by date
EFFECTIVE_DATE	DATE			Date the document becomes effective
EXPIRATION_DATE	DATE			Expiration date of the document
NOTE_TO_VENDOR	VARCHAR2	(480)		Note to the vendor
BUYER_FIRST_NAME	VARCHAR2	(150)		First name of the buyer for the document
BUYER_LAST_NAME	VARCHAR2	(150)	Yes	Last name of the buyer for the document
SHIP_VIA	VARCHAR2	(25)		Type of carrier to be used
FOB	VARCHAR2	(80)		Type of free-on-board terms for the document
FREIGHT_TERMS	VARCHAR2	(80)		Type of frieght terms for the document
REPLY_VIA	VARCHAR2	(25)		Type of reply method to be used
PAYMENT_TERMS	VARCHAR2	(50)		Payment terms for the document
CUSTOMER_NUM	VARCHAR2	(25)		Customer number with the vendor
VENDOR_NUM	VARCHAR2	(30)	Yes	Vendor number
VENDOR_NAME	VARCHAR2	(240)		Full name of the vendor
VENDOR_ADDRESS_LINE1	VARCHAR2	(240)		First line of vendor address
VENDOR_ADDRESS_LINE2	VARCHAR2	(240)		Second line of vendor address
VENDOR_ADDRESS_LINE3	VARCHAR2	(240)		Third line of vendor address
VENDOR_CITY	VARCHAR2	(60)		City name of the vendor
VENDOR_STATE	VARCHAR2	(60)		State name of the vendor
VENDOR_POSTAL_CODE	VARCHAR2	(20)		Postal code of the vendor
VENDOR_COUNTRY	VARCHAR2	(25)		Country of the vendor
VENDOR_PHONE	VARCHAR2	(28)		Phone number of the vendor
VENDOR_CONTACT_FIRST_NAME	VARCHAR2	(15)		First name of the vendor contact
VENDOR_CONTACT_LAST_NAME	VARCHAR2	(15)		Last name of the vendor contact
VENDOR_CONTACT_PHONE	VARCHAR2	(53)		Phone number of the vendor contact
SHIP_ADDRESS_LINE1	VARCHAR2	(240)		First line of ship to location address
SHIP_ADDRESS_LINE2	VARCHAR2	(240)		Second line of ship to location address
SHIP_ADDRESS_LINE3	VARCHAR2	(240)		Third line of ship to location address
SHIP_CITY	VARCHAR2	(80)		City name of ship to location
SHIP_STATE_PROVINCE	VARCHAR2	(120)		State or province name of ship to location
SHIP_POSTAL_CODE	VARCHAR2	(30)		Postal code of ship to location
SHIP_COUNTRY	VARCHAR2	(60)		Country of ship to location
BILL_ADDRESS_LINE1	VARCHAR2	(240)		First line of bill to location address
BILL_ADDRESS_LINE2	VARCHAR2	(240)		Second line of bill to location address
BILL_ADDRESS_LINE3	VARCHAR2	(240)		Third line of bill to location address
BILL_CITY	VARCHAR2	(80)		City name of bill to location
BILL_STATE_PROVINCE	VARCHAR2	(120)		State or province of bill to location
BILL_POSTAL_CODE	VARCHAR2	(30)		Postal code of bill to location
BILL_COUNTRY	VARCHAR2	(60)		Country of bill to location
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
BILL_TO_LOCATION_ID	NUMBER			Unique identifier for bill to location
SHIP_TO_LOCATION_ID	NUMBER			Unique identifier for ship to location
AGENT_ID	NUMBER	(9)	Yes	Buyer unique identifier
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
CURRENCY_CODE	VARCHAR2	(15)
LANGUAGE	VARCHAR2	(30)
SEQUENCE_NUM	NUMBER		Yes
ORG_ID	NUMBER			Organization identifier

Query Text

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


SELECT RFQ_NUM
,      REVISION_NUM
,      CREATION_DATE
,      PRINTED_DATE
,      REVISED_DATE
,      CLOSE_DATE
,      REPLY_BY_DATE
,      EFFECTIVE_DATE
,      EXPIRATION_DATE
,      NOTE_TO_VENDOR
,      BUYER_FIRST_NAME
,      BUYER_LAST_NAME
,      SHIP_VIA
,      FOB
,      FREIGHT_TERMS
,      REPLY_VIA
,      PAYMENT_TERMS
,      CUSTOMER_NUM
,      VENDOR_NUM
,      VENDOR_NAME
,      VENDOR_ADDRESS_LINE1
,      VENDOR_ADDRESS_LINE2
,      VENDOR_ADDRESS_LINE3
,      VENDOR_CITY
,      VENDOR_STATE
,      VENDOR_POSTAL_CODE
,      VENDOR_COUNTRY
,      VENDOR_PHONE
,      VENDOR_CONTACT_FIRST_NAME
,      VENDOR_CONTACT_LAST_NAME
,      VENDOR_CONTACT_PHONE
,      SHIP_ADDRESS_LINE1
,      SHIP_ADDRESS_LINE2
,      SHIP_ADDRESS_LINE3
,      SHIP_CITY
,      SHIP_STATE_PROVINCE
,      SHIP_POSTAL_CODE
,      SHIP_COUNTRY
,      BILL_ADDRESS_LINE1
,      BILL_ADDRESS_LINE2
,      BILL_ADDRESS_LINE3
,      BILL_CITY
,      BILL_STATE_PROVINCE
,      BILL_POSTAL_CODE
,      BILL_COUNTRY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      BILL_TO_LOCATION_ID
,      SHIP_TO_LOCATION_ID
,      AGENT_ID
,      PO_HEADER_ID
,      CURRENCY_CODE
,      LANGUAGE
,      SEQUENCE_NUM
,      ORG_ID
FROM APPS.PO_RFQ_HEADERS_PRINT;

Dependencies

[top of page]

APPS.PO_RFQ_HEADERS_PRINT references the following:

APPS: AP_TERMS; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES; FND_PROFILE - show dependent code; HR_EMPLOYEES; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PO_HEADERS; PO_LOOKUP_CODES; PO_RFQ_VENDORS; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.PO_RFQ_HEADERS_PRINT is not referenced by any database object