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.POS_PO_RFQ_HEADERS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This View Displays RFQ Header Information for all Organizations

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id
PO_HEADER_ID	NUMBER		Yes	Document Unique identifier
SEGMENT1	VARCHAR2	(20)	Yes	Key Flexfield enabled flag
SEGMENT2	VARCHAR2	(20)		Key Flexfield enabled flag
SEGMENT3	VARCHAR2	(20)		Key Flexfield enabled flag
SEGMENT4	VARCHAR2	(20)		Key Flexfield enabled flag
SEGMENT5	VARCHAR2	(20)		Key Flexfield enabled flag
DISPLAYED_QUOTE_TYPE	VARCHAR2	(80)	Yes	Document Type Name
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	Document Type Lookup Code
STATUS	VARCHAR2	(80)	Yes	Status of RFQ
STATUS_LOOKUP_CODE	VARCHAR2	(25)		Status Lookup Code
REVISION_NUM	NUMBER			Revision Number
VENDOR_ID	NUMBER			Supplier Unique Identifier
VENDOR_NAME	VARCHAR2	(240)		Supplier Name
VENDOR_SITE_ID	NUMBER			Supplier Site unique identifier
VENDOR_SITE_CODE	VARCHAR2	(15)		Supplier Site Code
VENDOR_CONTACT_ID	NUMBER			Supplier Contact Unique identifier
VENDOR_CONTACT	VARCHAR2	(32)		Supplier Contact
AGENT_ID	NUMBER	(9)	Yes	Employee id
AGENT_NAME	VARCHAR2	(240)		Employee Name
QUOTE_VENDOR_QUOTE_NUMBER	VARCHAR2	(25)		Number of the quotation for the supplier
FROM_HEADER_ID	NUMBER			Unique identifier of the RFQ used to autocreate a quotation
FROM_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Document type of the document used to autocreate another document
FROM_RFQ_NUMBER	VARCHAR2	(20)		RFQ Number used
RFQ_CLOSE_DATE	DATE			Date the RFQ will be closed
REPLY_METHOD_LOOKUP_CODE	VARCHAR2	(25)		Method the supplier should use to reply to the RFQ
REPLY_DATE	DATE			Reply Date
START_DATE	DATE			Date the document becomes effective
END_DATE	DATE			Expiration date of the document
SHIP_TO_LOCATION_ID	NUMBER			Ship to location unique identifier
SHIP_TO_LOCATION	VARCHAR2	(60)		Ship to location
BILL_TO_LOCATION_ID	NUMBER			Bill to location unique identifier
BILL_TO_LOCATION	VARCHAR2	(60)		Bill to location code
APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)		Approval required flaf
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
DISP_RATE_TYPE	VARCHAR2	(30)		Currency Display Rate type
RATE_TYPE	VARCHAR2	(30)		Currency rate Type
RATE_DATE	DATE			Currency Conversion Rate Date
RATE	NUMBER			Currency Conversion rate
COMMENTS	VARCHAR2	(240)		Descriptive Comment
TERMS_ID	NUMBER			Payment Terms unique identifier
PAYMENT_TERMS	VARCHAR2	(50)		Payment Terms Name
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)		Freight Terms Code
FREIGHT_TERMS_DSP	VARCHAR2	(80)		Displayed Field
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)		Carreir to be used
FOB_LOOKUP_CODE	VARCHAR2	(25)		FOB Lookup COde
FOB_DSP	VARCHAR2	(80)		Displayed Field
NOTE_TO_VENDOR	VARCHAR2	(480)		Short note for Supplier
QUOTE_WARNING_DELAY	NUMBER			Number of days prior to the expiration of the quotation that you want to be notified
QUOTATION_CLASS_CODE	VARCHAR2	(25)		Class of quotation
PRINTED_DATE	DATE			Date of print
REVISED_DATE	DATE			Revison date
CLOSED_DATE	DATE			Date of closure
QUOTE_TYPE_LOOKUP_CODE	VARCHAR2	(25)		Type of quotation
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Summary Flag
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled Flag
LAST_UPDATED_BY	NUMBER		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER			Standard Who Column
CREATED_BY	NUMBER			Standard Who Column
CREATION_DATE	DATE			Standard Who Column
CREATION_DATE_DISP	DATE			Standard Who Column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who Column
PROGRAM_ID	NUMBER			Standard Who Column
PROGRAM_UPDATE_DATE	DATE			Standard Who Column
REQUEST_ID	NUMBER			Standard Who Column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex Field
ORG_ID	NUMBER			Organization Unique Identifier
ORG_NAME	VARCHAR2	(240)		Organization Name

Query Text

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


SELECT ROW_ID
,      PO_HEADER_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      DISPLAYED_QUOTE_TYPE
,      TYPE_LOOKUP_CODE
,      STATUS
,      STATUS_LOOKUP_CODE
,      REVISION_NUM
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      VENDOR_CONTACT_ID
,      VENDOR_CONTACT
,      AGENT_ID
,      AGENT_NAME
,      QUOTE_VENDOR_QUOTE_NUMBER
,      FROM_HEADER_ID
,      FROM_TYPE_LOOKUP_CODE
,      FROM_RFQ_NUMBER
,      RFQ_CLOSE_DATE
,      REPLY_METHOD_LOOKUP_CODE
,      REPLY_DATE
,      START_DATE
,      END_DATE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      BILL_TO_LOCATION_ID
,      BILL_TO_LOCATION
,      APPROVAL_REQUIRED_FLAG
,      CURRENCY_CODE
,      DISP_RATE_TYPE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      COMMENTS
,      TERMS_ID
,      PAYMENT_TERMS
,      FREIGHT_TERMS_LOOKUP_CODE
,      FREIGHT_TERMS_DSP
,      SHIP_VIA_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      FOB_DSP
,      NOTE_TO_VENDOR
,      QUOTE_WARNING_DELAY
,      QUOTATION_CLASS_CODE
,      PRINTED_DATE
,      REVISED_DATE
,      CLOSED_DATE
,      QUOTE_TYPE_LOOKUP_CODE
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      CREATION_DATE_DISP
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ORG_ID
,      ORG_NAME
FROM APPS.POS_PO_RFQ_HEADERS_V;

Dependencies

[top of page]

APPS.POS_PO_RFQ_HEADERS_V references the following:

APPS: AP_TERMS; FND_GLOBAL - show dependent code; GL_DAILY_CONVERSION_TYPES; HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL; PER_ALL_PEOPLE_F; PO_DOCUMENT_TYPES_ALL_VL; PO_HEADERS_ALL; PO_LOOKUP_CODES; PO_RFQ_VENDORS; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.POS_PO_RFQ_HEADERS_V is not referenced by any database object