FND Design Data [Home] [Help]

Table: ASO_QUOTE_HEADERS_ALL

Product: ASO - Order Capture
Description: ASO_QUOTE_HEADERS holds Order Capture quotation information. it has the header data of a quote. For each quote header, there can zero or many quote lines attached to it.
Implementation/DBA Data: TableASO.ASO_QUOTE_HEADERS_ALL
Primary Key: ASO_QUOTE_HEADERS_ALL_PK
  1. ColumnQUOTE_HEADER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
ASO_QUOTE_HEADERS_ALL FK Joins to TableASO_QUOTE_STATUSES_B ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID
ASO_QUOTE_HEADERS_ALL FK Joins to TableHZ_PARTIES ASO_QUOTE_HEADERS_ALL.CUST_PARTY_ID
ASO_QUOTE_HEADERS_ALL FK Joins to TableHZ_PARTIES ASO_QUOTE_HEADERS_ALL.INVOICE_TO_CUST_PARTY_ID
ASO_QUOTE_HEADERS_ALL FK Joins to TableHZ_PARTIES ASO_QUOTE_HEADERS_ALL.INVOICE_TO_PARTY_ID
ASO_QUOTE_HEADERS_ALL FK Joins to TableHZ_PARTIES ASO_QUOTE_HEADERS_ALL.PARTY_ID
ASO_QUOTE_HEADERS_ALL FK Joins to TableHZ_PARTY_SITES ASO_QUOTE_HEADERS_ALL.INVOICE_TO_PARTY_SITE_ID
ASO_QUOTE_HEADERS_ALL FK Joins to TableHZ_PARTY_SITES ASO_QUOTE_HEADERS_ALL.SOLD_TO_PARTY_SITE_ID
TableASO_HEADER_RELATIONSHIPS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_HEADER_RELATIONSHIPS.QUOTE_HEADER_ID
TableASO_HEADER_RELATIONSHIPS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_HEADER_RELATIONSHIPS.RELATED_HEADER_ID
TableASO_PARTY_RELATIONSHIPS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_PARTY_RELATIONSHIPS.QUOTE_HEADER_ID
TableASO_PAYMENTS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_PAYMENTS.QUOTE_HEADER_ID
TableASO_PRICE_ADJUSTMENTS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_PRICE_ADJUSTMENTS.QUOTE_HEADER_ID
TableASO_PRICE_ATTRIBUTES FK Joins to ASO_QUOTE_HEADERS_ALL ASO_PRICE_ATTRIBUTES.QUOTE_HEADER_ID
TableASO_QUOTE_LINES_ALL FK Joins to ASO_QUOTE_HEADERS_ALL ASO_QUOTE_LINES_ALL.QUOTE_HEADER_ID
TableASO_QUOTE_LINE_ATTRIBS_EXT FK Joins to ASO_QUOTE_HEADERS_ALL ASO_QUOTE_LINE_ATTRIBS_EXT.QUOTE_HEADER_ID
TableASO_QUOTE_PARTIES FK Joins to ASO_QUOTE_HEADERS_ALL ASO_QUOTE_PARTIES.QUOTE_HEADER_ID
TableASO_QUOTE_RELATED_OBJECTS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_QUOTE_RELATED_OBJECTS.QUOTE_OBJECT_ID
TableASO_SALES_CREDITS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_SALES_CREDITS.QUOTE_HEADER_ID
TableASO_SHIPMENTS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_SHIPMENTS.QUOTE_HEADER_ID
TableASO_TAX_DETAILS FK Joins to ASO_QUOTE_HEADERS_ALL ASO_TAX_DETAILS.QUOTE_HEADER_ID
TableIBE_ACTIVE_QUOTES_ALL FK Joins to ASO_QUOTE_HEADERS_ALL IBE_ACTIVE_QUOTES_ALL.QUOTE_HEADER_ID
TableIBE_LEAD_IMPORT_DETAILS FK Joins to ASO_QUOTE_HEADERS_ALL IBE_LEAD_IMPORT_DETAILS.QUOTE_HEADER_ID
TableIBE_SH_QUOTE_ACCESS FK Joins to ASO_QUOTE_HEADERS_ALL IBE_SH_QUOTE_ACCESS.QUOTE_HEADER_ID
TableJAI_CRM_QUOTE_TAXES FK Joins to ASO_QUOTE_HEADERS_ALL JAI_CRM_QUOTE_TAXES.QUOTE_HEADER_ID
TablePRP_PROPOSAL_OBJECTS FK Joins to ASO_QUOTE_HEADERS_ALL PRP_PROPOSAL_OBJECTS.OBJECT_ID