Send Request For Quotation Service

Field Name	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION_ ID
DOCUMENT_TYPE			Use RFQ.
DOCUMENT_ STATUS			Use INSERT or UPDATE.
RFQ_ID	PO_HEADERS_ ALL PO_RFQ_VENDORS	PO_HEADER_ ID PO_HEADER_ID	Request For Quotation (RFQ) identifier.
PO_HEADER_ID	PO_HEADERS_ ALL	PO_HEADER_ ID	Required for outbound transactions. Unique identifier for the RFQ header.
RFQ_NUMBER	PO_HEADERS_ ALL	SEGMENT1
VENDOR_NAME	PO_HEADERS_ ALL	VENDOR_ NAME
VENDOR_ ADDRESS_LINE1	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE1
VENDOR_ ADDRESS_LINE2	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE2
VENDOR_ ADDRESS_LINE3	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE3
VENDOR_CITY	AP_SUPPLIER_ SITES_ALL	CITY
VENDOR_STATE	AP_SUPPLIER_ SITES_ALL	STATE
VENDOR_ZIP	AP_SUPPLIER_ SITES_ALL	ZIP
VENDOR_COUNTRY	AP_SUPPLIER_ SITES_ALL	COUNTRY
VENDOR_PHONE	AP_SUPPLIER_ SITES_ALL	AREA_CODE + PHONE
VENDOR_FAX	AP_SUPPLIER_ SITES_ALL	FAX_AREA_CODE + FAX
VENDOR_ CONTACT_NAME	PO_VENDOR_ CONTACTS	PERSON_LAST_NAME + PERSON_FIRST_NAME
VENDOR_ PRINT_FLAG	PO_RFQ_ VENDORS	PRINT_FLAG
VENDOR_ PRINT_COUNT	PO_RFQ_ VENDORS	PRINT_COUNT	Vendor RFQ print count.
VENDOR_ PRINTED_DATE	PO_RFQ_ VENDORS	PRINTED_DATE	RFQ printed date.
HOLD_FLAG	AP_SUPPLIERS	HOLD_FLAG
DOCUMENT_ TYPE_NAME	PO_DOCUMENT_ TYPES	NAME	Name of the RFQ document type.
CREATED	PO_HEADERS_ALL	CREATION_ DATE	Date the RFQ was created.
TYPE_LOOKUP_ CODE	PO_HEADERS_ALL	TYPE_LOOKUP_ CODE	Type of the document.
RFQ_STATUS	PO_HEADERS_ALL	STATUS_LOOKUP_ CODE	Status of the RFQ: In Process, Active, or Closed.
REVISION_NUM	PO_HEADERS_ALL	REVISION_NUM	RFQ revision number.
SHIP_TO_ LOCATION_ADD_LINE_1	HR_LOCATIONS	ADDRESS_LINE_1	Address where the PO items will be shipped. Derives the SHIP_TO_LOCATION_ID.
SHIP_TO_ LOCATION_ADD_ LINE_2	HR_LOCATIONS	ADDRESS_LINE_2
SHIP_TO_ LOCATION_ ADD_LINE_3	HR_LOCATIONS	ADDRESS_LINE_3
SHIP_TO_ LOCATION_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
SHIP_TO_ LOCATION_ COUNTY	HR_LOCATIONS	REGION_1
SHIP_TO_ LOCATION_STATE	HR_LOCATIONS	REGION_2
SHIP_TO_ LOCATION_ REGION_3	HR_LOCATIONS	REGION_3
SHIP_TO_ LOCATION_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_TO_ LOCATION_ COUNTRY	HR_LOCATIONS	COUNTRY
BILL_TO_ LOCATION_ ADD_LINE_1	HR_LOCATIONS	ADDRESS_LINE_1	Address where the bill will be sent. Derives the BILL_TO_LOCATION_ID.
BILL_TO_ LOCATION_ ADD_LINE_2	HR_LOCATIONS	ADDRESS_LINE_2
BILL_TO_ LOCATION_ ADD_LINE_3	HR_LOCATIONS	ADDRESS_LINE_3
BILL_TO_ LOCATION_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
BILL_TO_ LOCATION_ COUNTY	HR_LOCATIONS	REGION_1
BILL_TO_ LOCATION_ STATE	HR_LOCATIONS	REGION_2
BILL_TO_ LOCATION_ REGION_3	HR_LOCATIONS	REGION_3
BILL_TO_ LOCATION_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
BILL_TO_ LOCATION_ COUNTRY	HR_LOCATIONS	COUNTRY
AGENT_NAME	PER_ALL_ PEOPLE_F	NAME	Buyer’s name.
COMMENTS	PO_HEADERS_ALL	COMMENTS	Comments about the RFQ.
QUOTE_VENDOR_ QUOTE_NUMBER	VENDOR_ DOC_NUM	QUOTE_VENDOR_ QUOTE_NUMBER	Supplier document number.
FROM_TYPE_ LOOKUP_CODE	PO_HEADERS_ ALL	FROM_TYPE_ LOOKUP_CODE
FROM_RFQ_ NUMBER	PO_HEADERS_ ALL	SEGMENT1
RFQ_CLOSE_DATE	PO_HEADERS_ ALL	RFQ_CLOSE_DATE
REPLY_VIA	PO_HEADERS_ ALL	REPLY_METHOD_ LOOKUP_CODE	Method the supplier should use to reply to the RFQ.
REPLY_DATE	PO_HEADERS_ ALL	REPLY_DATE	Due date of reply for the RFQ.
START_DATE	PO_HEADERS_ ALL	START_DATE	Effective date for the RFQ.
END_DATE	PO_HEADERS_ ALL	END_DATE	Expiration date for the RFQ.
APPROVAL_ REQUIRED_ FLAG	PO_HEADERS_ ALL	APPROVAL_ REQUIRED_ FLAG	Indicates whether approval is required for the RFQ.
CURRENCY_CODE	PO_HEADERS_ ALL	CURRENCY_CODE	Currency code for the RFQ.
USER_ CONVERSION_ TYPE	PO_HEADERS_ ALL	USER_ CONVERSION_ TYPE	Conversion type used.
RATE_TYPE	PO_HEADERS_ ALL	RATE_TYPE	Currency conversion rate type.
RATE_DATE	PO_HEADERS_ ALL	RATE_DATE	Currency conversion rate date.
RATE	PO_HEADERS_ ALL	RATE	Currency conversion rate.
TERMS_NAME	AP_TERMS	NAME	Payment terms for the RFQ.
FREIGHT_TERMS	PO_HEADERS_ ALL	FREIGHT_TERMS	Freight payment terms.
SHIP_VIA_ LOOKUP_CODE	PO_HEADERS_ ALL	SHIP_VIA_ LOOKUP_CODE	Code indicating the shipping medium, such as UPS or FEDEX.
FOB	PO_HEADERS_ ALL	FOB	Type of Free On Board terms for the document.
NOTE_TO_VENDOR	PO_HEADERS_ ALL	NOTE_TO_VENDOR
QUOTE_ WARNING_ DELAY	PO_HEADERS_ ALL	QUOTE_ WARNING_ DELAY	Number of days before the expiration of the quotation.
QUOTATION_ CLASS_CODE	PO_HEADERS_ ALL	QUOTATION_ CLASS_CODE
REVISED_DATE	PO_HEADERS_ ALL	REVISED_DATE	Date the document was last revised.
CLOSED_DATE	PO_HEADERS_ ALL	CLOSED_DATE	Date when the document was closed.
QUOTE_TYPE_ LOOKUP_CODE	PO_HEADERS_ ALL	QUOTE_TYPE_ LOOKUP_CODE

Field Name	Oracle Applications Table/View Name	Column Name	Description
PO_LINE_ID	PO_LINES_ALL	PO_LINE_ID	Required for outbound transactions. Unique identifier for RFQ line.
LINE_NUM	PO_LINES_ALL	LINE_NUM	Line number.
LINE_TYPE	PO_LINES_ALL	LINE_TYPE
ITEM_NUMBER	MTL_SYSTEM_ ITEMS	SEGMENT1
ITEM_REVISION	PO_LINES_ALL	ITEM_REVISION
ITEM_CATEGORY	MTL_CATEGORIES_ KFV	CONCATENATED_ SEGMENTS
ITEM_DESCRIPTION	PO_LINES_ALL	ITEM_DESCRIPTION
UNIT_MEAS_ LOOKUP_CODE	PO_LINES_ALL	UNIT_MEAS_ LOOKUP_CODE	Unit of measurement for the items.
UOM_CLASS	MTL_UNITS_OF_ MEASURE_TL	UOM_CLASS	Unit of measurement class.
UNIT_PRICE	PO_LINES_ALL	UNIT_PRICE
VENDOR_ PRODUCT_ NUM	PO_LINES_ALL	VENDOR_ PRODUCT_ NUM	Supplier’s item number ordered.
UN_NUMBER	PO_LINES_ALL	UN_NUMBER
HAZARD_CLASS	PO_LINES_ALL	HAZARD_ CLASS
MIN_ORDER_ QUANTITY	PO_UN_NUMBERS	MIN_ORDER_ QUANTITY	Minimum order quantity for the RFQ.
MAX_ORDER_ QUANTITY	PO_HAZARD_ CLASSES	MAX_ORDER_ QUANTITY	Maximum order quantity for the RFQ.
NOTE_TO_ VENDOR	PO_LINES_ALL	NOTE_TO_ VENDOR	Note to the supplier.
FROM_RFQ_ NUMBER	PO_LINES_ALL	FROM_RFQ_ NUMBER
FROM_LINE_ NUMBER	PO_LINES_ALL	FROM_LINE_ NUMBER
TAXABLE_FLAG	PO_LINES_ALL	TAXABLE_FLAG
QUANTITY	PO_LINES_ALL	QUANTITY
ALLOW_ITEM_ DESC_UPDATE_ FLAG	MTL_CATEGORIES_ KFV	ALLOW_ITEM_ DESC_UPDATE_ FLAG	Indicates whether item description update is allowed.
ALLOWED_ UNITS_LOOKUP_ CODE	MTL_ CATEGORIES_ KFV	ALLOWED_ UNITS_LOOKUP_ CODE	Code for allowed units of the items in the RFQ.
ORDER_TYPE_ LOOKUP_CODE	PO_LINE_TYPES	ORDER_TYPE_ LOOKUP_CODE
OUTSIDE_ OPERATION_ FLAG	PO_LINE_TYPES	OUTSIDE_ OPERATION_ FLAG
PROJECT_NAME	PA_PROJECTS_ ALL	PROJECT_NAME
TASK_NAME	PA_TASKS	TASK_NAME
QC_GRADE	PO_LINES_ALL	QC_GRADE
BASE_UOM	PO_LINES_ALL	BASE_UOM	Base unit of measurement.
BASE_QTY	PO_LINES_ALL	BASE_QTY	Base quantity.
SECONDARY_ UOM	PO_LINES_ALL	SECONDARY_ UOM	Stores the dual unit of measure for the item ordered.
SECONDARY_ QTY	PO_LINES_ALL	SECONDARY_ QTY	Converted quantity from BASE unit of measurement to DUAL unit of measurement for the item ordered.

Field Name	Oracle Applications Table/View Name	Column Name	Description
SHIPMENT_TYPE	PO_LINE_ LOCATIONS_ALL	SHIPMENT_TYPE	RFQ shipment type.
SHIP_TO_ ORG_NAME	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME	Organization that will receive the shipped items.
QUANTITY	PO_LINE_ LOCATIONS_ALL	QUANTITY
QUANTITY_ ACCEPTED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ ACCEPTED
QUANTITY_ BILLED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ BILLED
QUANTITY_ CANCELLED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ CANCELLED
QUANTITY_ RECEIVED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ RECEIVED
QUANTITY_ REJECTED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ REJECTED
UOM	PO_LINE_ LOCATIONS_ALL	UOM	Unit of measurement.
PRICE_OVERRIDE	PO_LINE_ LOCATIONS_ALL	PRICE_OVERRIDE
UNIT_PRICE	PO_LINES_ALL	UNIT_PRICE	Unit price of the item in RFQ.
NOT_TO_ EXCEED_PRICE	PO_LINES_ALL	NOT_TO_ EXCEED_PRICE	Maximum price of the item.
ALLOW_PRICE_ OVERRIDE_FLAG	PO_LINES_ALL	ALLOW_PRICE_ OVERRIDE_FLAG	Indicates whether price override is allowed.
PRICE_BREAK_ LOOKUP_CODE	PO_LINES_ALL	PRICE_BREAK_ LOOKUP_CODE
PRICE	PO_LINE_ LOCATIONS_ALL	PRICE	Price of the item in the RFQ.
LAST_ACCEPT_ DATE	PO_LINE_ LOCATIONS_ALL	LAST_ACCEPT_ DATE	Date when the item can be last accepted.
NEED_BY_DATE	PO_LINE_ LOCATIONS_ALL	NEED_BY_DATE	Date by which the item in the RFQ needs to be shipped.
PROMISED_DATE	PO_LINE_ LOCATIONS_ALL	PROMISED_DATE	Date promised by the supplier when the item would be delivered.
FIRM_STATUS_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	FIRM_STATUS_ LOOKUP_CODE	Firming status of the line.
PRICE_DISCOUNT	PO_LINE_ LOCATIONS_ALL	PRICE_DISCOUNT	Discount percentage for price break.
START_DATE	PO_LINE_ LOCATIONS_ALL	START_DATE	Effective date.
END_DATE	PO_LINE_ LOCATIONS_ALL	END_DATE	Expiration date.
LEAD_TIME	PO_LINE_ LOCATIONS_ALL	LEAD_TIME	Lead time for the price break.
LEAD_TIME_UNIT	PO_LINE_ LOCATIONS_ALL	LEAD_TIME_UNIT
TERMS_NAME	AP_TERMS	NAME
FREIGHT_TERMS_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	FREIGHT_TERMS_ LOOKUP_CODE	Lookup code for freight terms.
FOB_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	FOB_ LOOKUP_CODE	Free on Board lookup code.
SHIP_VIA_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	SHIP_VIA_ LOOKUP_CODE	Type of carrier for the RFQ or quotation shipment.
TAX_NAME	AP_TAX_CODES_ALL	NAME
TAXABLE_FLAG	PO_LINE_ LOCATIONS_ALL	TAXABLE_FLAG	Indicates whether the price break is taxable.
INSPECTION_ REQUIRED_ FLAG	PO_LINE_ LOCATIONS_ALL	INSPECTION_ REQUIRED_ FLAG	Indicates whether shipment must be inspected before the invoice is paid.
RECEIPT_ REQUIRED_ FLAG	PO_LINE_ LOCATIONS_ALL	RECEIPT_ REQUIRED_ FLAG	Indicates whether shipment must be received before the invoice is paid.
RECEIVE_ CLOSE_ TOLERANCE	PO_LINE_ LOCATIONS_ALL	RECEIVE_ CLOSE_ TOLERANCE	Percentage tolerance within which the shipment is automatically closed for receiving.
INVOICE_ CLOSE_ TOLERANCE	PO_LINE_ LOCATIONS_ALL	INVOICE_ CLOSE_ TOLERANCE	Percentage tolerance within which the shipment is automatically closed for invoicing when billed.
QTY_RCV_ EXCEPTION_CODE	PO_LINE_ LOCATIONS_ALL	QTY_RCV_ EXCEPTION_CODE	Describes the action taken when the quantity received tolerance is exceeded.
DAYS_EARLY_ RECEIPT_ ALLOWED	PO_LINE_ LOCATIONS_ALL	DAYS_EARLY_ RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early.
DAYS_LATE_ RECEIPT_ ALLOWED	PO_LINE_ LOCATIONS_ALL	DAYS_LATE_ RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late.
QTY_RCV_ TOLERANCE	PO_LINE_ LOCATIONS_ALL	QTY_RCV_ TOLERANCE	Maximum over–receipt tolerance percentage.
ROUTING_NAME	RCV_ROUTING_HEADERS	NAME
ENFORCE_ SHIP_TO_ LOCATION_CODE	PO_LINE_ LOCATIONS_ALL	ENFORCE_ SHIP_TO_ LOCATION_CODE	Describes the action taken when the receiving location differs from the Ship To location.
RECEIPT_DAYS_ EXCEPTION_CODE	PO_LINE_ LOCATIONS_ALL	RECEIPT_DAYS_ EXCEPTION_CODE	Describes what action is taken when items are received earlier or later than the allowed number of days specified.
ACCRUE_ON_ RECEIPT_FLAG	PO_LINE_ LOCATIONS_ALL	ACCRUE_ON_ RECEIPT_FLAG	Indicates whether items are accrued upon receipt.
ALLOW_ SUBSTITUTE_ RECEIPTS_FLAG	PO_LINE_ LOCATIONS_ALL	ALLOW_ SUBSTITUTE_ RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items.
FROM_PO_ HEADER_NUM	PO_HEADERS_ ALL	SEGMENT1	Unique identifier of the RFQ to automatically create the quotation.
FROM_PO_ LINE_NUM	PO_LINES_ALL	LINE_NUM	Unique identifier of the RFQ line used to automatically create the quotation line.
ENCUMBERED_ FLAG	PO_LINE_ LOCATIONS_ALL	ENCUMBERED_ FLAG	Indicates whether the shipment is encumbered.
ENCUMBERED_ DATE	PO_LINE_ LOCATIONS_ALL	ENCUMBERED_ DATE	Date of encumbrance for the shipment.
APPROVED_FLAG	PO_LINE_ LOCATIONS_ALL	APPROVED_FLAG	Indicates whether the shipment is approved.
CLOSED_CODE	PO_LINE_ LOCATIONS_ALL	CLOSED_CODE	Closure status of the shipment.
CANCEL_FLAG	PO_LINE_ LOCATIONS_ALL	CANCEL_FLAG	Indicates whether the shipment is cancelled.
CANCEL_DATE	PO_LINE_ LOCATIONS_ALL	CANCEL_DATE
CANCEL_REASON	PO_LINE_ LOCATIONS_ALL	CANCEL_REASON	Cancellation reason provided by the employee.
CLOSED_BY_ PERSON_NAME	PER_ALL_ PEOPLE_F	PERSON_LAST_NAME. PERSON_FIRST_NAME	Employee who closed the shipment.
CLOSED_DATE	PO_LINE_ LOCATIONS_ALL	CLOSED_DATE	Date the shipment closed.
CLOSED_REASON	PO_LINE_ LOCATIONS_ALL	CLOSED_REASON	Why the shipment closed.
USSGL_ TRANSACTION_ CODE	PO_LINE_ LOCATIONS_ALL	USSGL_ TRANSACTION_ CODE	United States standard general ledger transaction code.
GOVERNMENT_ CONTEXT	PO_LINE_ LOCATIONS_ALL	GOVERNMENT_ CONTEXT	United States standard general ledger descriptive flexfield context column.
LINE_TYPE	PO_LINE_TYPES	LINE_TYPE	Document line type.
OUTSIDE_ OPERATION_ FLAG	PO_LINE_TYPES	OUTSIDE_ OPERATION_ FLAG	Indicates whether the line type is an outside operation.
RECEIVING_FLAG	PO_LINE_TYPES	RECEIVING_FLAG	Default receipt required flag.
ITEM_NUMBER	MTL_SYSTEM_ITEMS	SEGMENT1
ITEM_DESCRIPTION	PO_LINE_ LOCATIONS_ALL	ITEM_DESCRIPTION
ITEM_REVISION	PO_LINE_ LOCATIONS_ALL	ITEM_REVISION
PLANNING_CODE	MTL_SYSTEM_ ITEMS	MRP_PLANNING_ CODE / INVENTORY_ PLANNING_ CODE
STOCK_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS	STOCK_ ENABLED_FLAG	Indicates whether the item is in stock.
OUTSIDE_ OPERATION_ UOM_TYPE	MTL_SYSTEM_ ITEMS	OUTSIDE_ OPERATION_ UOM_TYPE	Outside operation unit of measurement.
CATEGORY_NAME	MTL_CATEGORIES_ KFV	CONCATENATED_ SEGMENTS	Item category name.
VENDOR_ PRODUCT_ NUM	PO_LINES_ALL	VENDOR_ PRODUCT_ NUM	Supplier product number.
COUNTRY_OF_ ORIGIN_CODE	PO_LINE_ LOCATIONS_ALL	COUNTRY_OF_ ORIGIN_CODE	Country of manufacture for this shipment.
TAX_USER_ OVERRIDE_FLAG	PO_LINE_ LOCATIONS_ALL	TAX_USER_ OVERRIDE_FLAG	Indicates whether someone overrode the default tax.
MATCH_OPTION	PO_LINE_ LOCATIONS_ALL	MATCH_OPTION	Indicates whether the invoice for the shipment should be matched to the purchase order or the receipt.
CALCULATE_ TAX_FLAG	PO_LINE_ LOCATIONS_ALL	CALCULATE_ TAX_FLAG	Indicates whether tax needs to be calculated.
NOTE_TO_ RECEIVER	PO_LINE_ LOCATIONS_ALL	NOTE_TO_ RECEIVER
SECONDARY_ UNIT_OF_MEASURE	PO_LINES_ALL	SECONDARY_ UNIT_OF_MEASURE	Stores the dual unit of measure for the item ordered.
SECONDARY_ QUANTITY	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY	Stores the dual quantity for the item ordered.
PREFERRED_ GRADE	PO_LINE_ LOCATIONS_ALL	PREFERRED_ GRADE	Preferred grade of the item ordered.
SECONDARY_ QUANTITY_ RECEIVED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ RECEIVED	Stores the dual quantity received for the item ordered.
SECONDARY_ QUANTITY_ ACCEPTED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ ACCEPTED	Stores the dual quantity accepted for the item ordered.
SECONDARY_ QUANTITY_ REJECTED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ REJECTED	Stores the dual quantity rejected for the item ordered.
SECONDARY_ QUANTITY_ CANCELLED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ CANCELLED	Stores the dual quantity cancelled for the item ordered.

Script	Description
wm_install_from_rfq.sql	Runs the scripts listed below, except the uninstall script.
wm_from_rfq_vw.sql	Creates the following required view components for RFQ outbound transactions: WM_RFQ_HEADERS_VW WM_RFQ_LINES_VW WM_RFQ_PRICE_BREAKS_VW WM_RFQ_QRY_VW
wm_from_rfq_trg.sql	Creates the following trigger component to be used for writing to wm_trackchanges to indicate a new or updated document: WM_PO_RFQ_VENDORS_IU_TRG
wm_disable_from_rfq.sql	Disables the triggers installed by wm_from_rfq_trg.sql.
wm_enable_from_rfq.sql	Re-enables the triggers installed by wm_from_rfq_trg.sql.
wm_drop_from_rfq.sql	Uninstalls all components created by wm_install_from_rfq.sql.