[Home] [Help] [Dependency Information]
Object Name: | CZ_QUOTE_HDRS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_QUOTE_HDRS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_QUOTE_HDRS_PK | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
QUOTE_HDR_ID
QUOTE_REV_NBR |
CZ_QUOTE_HDRS_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | OPPORTUNITY_HDR_ID |
CZ_QUOTE_HDRS_N10 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | BILLTO_CONTACT_ID |
CZ_QUOTE_HDRS_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | USER_ID_FOR_WHOM_CREATED |
CZ_QUOTE_HDRS_N3 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | USER_ID_CREATED |
CZ_QUOTE_HDRS_N4 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | BILLTO_CUSTOMER_ID |
CZ_QUOTE_HDRS_N5 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SHIPTO_CUSTOMER_ID |
CZ_QUOTE_HDRS_N6 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | BILLTO_ADDRESS_ID |
CZ_QUOTE_HDRS_N7 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SHIPTO_ADDRESS_ID |
CZ_QUOTE_HDRS_N8 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | MAIN_CONTACT_ID |
CZ_QUOTE_HDRS_N9 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | SHIPTO_CONTACT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LAST_UPDATE_LOGIN | NUMBER | (15) | Records the login ID under which this record was last updated | |
QUOTE_HDR_ID | NUMBER | (9) | Yes | Associates this record with a customer quote |
QUOTE_REV_NBR | NUMBER | (9) | Yes | Identifies the revision of the associated customer quote |
BILLTO_CONTACT_ID | NUMBER | (9) | Specifies a contact to be billed for this quote's order | |
BILLTO_ADDRESS_ID | NUMBER | (9) | Address to which this quote's order should be billed | |
MAIN_CONTACT_ID | NUMBER | (9) | Identifies the main contact for this quote | |
BILLTO_CUSTOMER_ID | NUMBER | (9) | Identifies the customer to be billed for this quote's order | |
TAX_STATE | NUMBER | (16) | Amount of state tax levied on this order | |
SHIPPING | NUMBER | (16) | Shipping value | |
BOM_DOC_PATH_NAME | VARCHAR2 | (100) | Path to a BOM document for this order | |
QUOTE_NOTE_REP | VARCHAR2 | (255) | Note to sales rep about this quote | |
QUOTE_DOC_PATH_NAME | VARCHAR2 | (100) | Filename path to the document containing this quote | |
QUOTE_SHORTDOC_PATH_NAME | VARCHAR2 | (150) | Filename path to the quote summary doc | |
USER_ID_CREATED | NUMBER | (9) | Yes | Identifies the actual applications user that created this record |
USER_ID_FOR_WHOM_CREATED | NUMBER | (9) | Yes | Records the user (salesrep) for whom this record was created |
QUOTE_VIOLATION_FLAG | VARCHAR2 | (1) | Indicates whether this quote has violations in the config | |
TAX_CITY | NUMBER | (16) | Amount of municipal/county tax levied on this order | |
OPPORTUNITY_HDR_ID | NUMBER | (9) | Yes | Associates this record with a customer Opportunity |
QUOTE_NAME | VARCHAR2 | (255) | Name of this quote | |
QUOTE_DESC | VARCHAR2 | (255) | Description of this quote | |
DISC_PERCENTAGE | NUMBER | (16) | Indicates the percentage discount associated with this record | |
DISC_TYPE | VARCHAR2 | (1) | Indicates the type of discount applied to this record | |
QUOTE_CREATED_DATE | DATE | Date quote was created | ||
QUOTE_EXPIRATION_DATE | DATE | Date at which the quote is no longer binding | ||
QUOTE_EFFECTIVE_DATE | DATE | Binding effective date for this quote | ||
QUOTE_NOTE_PRINT | VARCHAR2 | (255) | Printable note about this quote | |
QUOTE_STATUS | VARCHAR2 | (20) | Status of this quote | |
OTHER_CHARGES | NUMBER | (16) | Records other charged applicable to this quote | |
TAX_FEDERAL | NUMBER | (16) | Amount of federal tax levied on this order | |
PRICE_GROUP_ID | NUMBER | (9) | Yes | Associates this quote with a price group |
SHIPTO_CONTACT_ID | NUMBER | (9) | Contact to which this order should be shipped | |
TOTAL_QUOTED_PRICE | NUMBER | (18) | Total price quoted for this order | |
ORDER_REQUEST_FLAG | VARCHAR2 | (1) | Indicates the ordering status of this quote | |
ORACLE_PRICING_FLAG | VARCHAR2 | (1) | '1' indicates whether this quote is to be repriced by Oracle on order entry. '0' indicates local quoted pricing will override oracle pricing | |
SHIPTO_CUSTOMER_ID | NUMBER | (9) | Customer to whom the order will be shipped | |
SHIPTO_ADDRESS_ID | NUMBER | (9) | Address to which this order should be shipped | |
ORDER_SUBMITTED_DATE | DATE | Date order was submitted | ||
SO_PRICE_LIST_ID | NUMBER | Order-entry price list ID for ordering | ||
USER_NUM01 | NUMBER | (16) | Standard extension field (numeric) | |
USER_NUM02 | NUMBER | (16) | Standard extension field (numeric) | |
USER_NUM03 | NUMBER | (16) | Standard extension field (numeric) | |
USER_NUM04 | NUMBER | (16) | Standard extension field (numeric) | |
USER_STR01 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR02 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR03 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR04 | VARCHAR2 | (255) | Standard extension field (string) | |
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
EFF_FROM | DATE | UNUSED | ||
EFF_TO | DATE | UNUSED | ||
CREATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that created this record |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard field recording the ID of the user that last updated this record |
SECURITY_MASK | VARCHAR2 | (40) | UNUSED | |
EFF_MASK | VARCHAR2 | (40) | UNUSED | |
CHECKOUT_USER | VARCHAR2 | (40) | UNUSED |
Cut, paste (and edit) the following text to query this object:
SELECT LAST_UPDATE_LOGIN
, QUOTE_HDR_ID
, QUOTE_REV_NBR
, BILLTO_CONTACT_ID
, BILLTO_ADDRESS_ID
, MAIN_CONTACT_ID
, BILLTO_CUSTOMER_ID
, TAX_STATE
, SHIPPING
, BOM_DOC_PATH_NAME
, QUOTE_NOTE_REP
, QUOTE_DOC_PATH_NAME
, QUOTE_SHORTDOC_PATH_NAME
, USER_ID_CREATED
, USER_ID_FOR_WHOM_CREATED
, QUOTE_VIOLATION_FLAG
, TAX_CITY
, OPPORTUNITY_HDR_ID
, QUOTE_NAME
, QUOTE_DESC
, DISC_PERCENTAGE
, DISC_TYPE
, QUOTE_CREATED_DATE
, QUOTE_EXPIRATION_DATE
, QUOTE_EFFECTIVE_DATE
, QUOTE_NOTE_PRINT
, QUOTE_STATUS
, OTHER_CHARGES
, TAX_FEDERAL
, PRICE_GROUP_ID
, SHIPTO_CONTACT_ID
, TOTAL_QUOTED_PRICE
, ORDER_REQUEST_FLAG
, ORACLE_PRICING_FLAG
, SHIPTO_CUSTOMER_ID
, SHIPTO_ADDRESS_ID
, ORDER_SUBMITTED_DATE
, SO_PRICE_LIST_ID
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, CREATION_DATE
, LAST_UPDATE_DATE
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, EFF_MASK
, CHECKOUT_USER
FROM CZ.CZ_QUOTE_HDRS;
CZ.CZ_QUOTE_HDRS does not reference any database object
CZ.CZ_QUOTE_HDRS is referenced by following:
|
|
|