DBA Data[Home] [Help] [Dependency Information]

TYPE: APPS.ASO_QUOTE_PUB_QTE_HEADER_REC_

Object Details
Object Name: ASO_QUOTE_PUB_QTE_HEADER_REC_
Object Type: TYPE
Owner: APPS
Subobject Name:
Status: VALID
Type Details
Type Code: OBJECT
Predefined: NO
Incomplete: NO
Attributes
Name Datatype Length Prcn
QUOTE_HEADER_ID NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

ORG_ID NUMBER

QUOTE_NAME VARCHAR2 (240)
QUOTE_NUMBER NUMBER

QUOTE_VERSION NUMBER

QUOTE_STATUS_ID NUMBER

QUOTE_SOURCE_CODE VARCHAR2 (240)
QUOTE_EXPIRATION_DATE DATE

PRICE_FROZEN_DATE DATE

QUOTE_PASSWORD VARCHAR2 (240)
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 (240)
PARTY_ID NUMBER

CUST_ACCOUNT_ID NUMBER

INVOICE_TO_CUST_ACCOUNT_ID NUMBER

ORG_CONTACT_ID NUMBER

PHONE_ID NUMBER

INVOICE_TO_PARTY_SITE_ID NUMBER

INVOICE_TO_PARTY_ID NUMBER

ORIG_MKTG_SOURCE_CODE_ID NUMBER

MARKETING_SOURCE_CODE_ID NUMBER

ORDER_TYPE_ID NUMBER

QUOTE_CATEGORY_CODE VARCHAR2 (240)
ORDERED_DATE DATE

ACCOUNTING_RULE_ID NUMBER

INVOICING_RULE_ID NUMBER

EMPLOYEE_PERSON_ID NUMBER

PRICE_LIST_ID NUMBER

CURRENCY_CODE VARCHAR2 (15)
TOTAL_LIST_PRICE NUMBER

TOTAL_ADJUSTED_AMOUNT NUMBER

TOTAL_ADJUSTED_PERCENT NUMBER

TOTAL_TAX NUMBER

TOTAL_SHIPPING_CHARGE NUMBER

SURCHARGE NUMBER

TOTAL_QUOTE_PRICE NUMBER

PAYMENT_AMOUNT NUMBER

EXCHANGE_RATE NUMBER

EXCHANGE_TYPE_CODE VARCHAR2 (15)
EXCHANGE_RATE_DATE DATE

CONTRACT_ID NUMBER

SALES_CHANNEL_CODE VARCHAR2 (30)
ORDER_ID NUMBER

ORDER_NUMBER NUMBER

FFM_REQUEST_ID NUMBER

QTE_CONTRACT_ID NUMBER

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
SALESREP_FIRST_NAME VARCHAR2 (255)
SALESREP_LAST_NAME VARCHAR2 (255)
PRICE_LIST_NAME VARCHAR2 (255)
QUOTE_STATUS_CODE VARCHAR2 (30)
QUOTE_STATUS VARCHAR2 (240)
PARTY_NAME VARCHAR2 (255)
PARTY_TYPE VARCHAR2 (30)
PERSON_FIRST_NAME VARCHAR2 (150)
PERSON_MIDDLE_NAME VARCHAR2 (60)
PERSON_LAST_NAME VARCHAR2 (150)
MARKETING_SOURCE_NAME VARCHAR2 (150)
MARKETING_SOURCE_CODE VARCHAR2 (150)
ORDER_TYPE_NAME VARCHAR2 (240)
INVOICE_TO_PARTY_NAME VARCHAR2 (255)
INVOICE_TO_CONTACT_FIRST_NAME VARCHAR2 (150)
INVOICE_TO_CONTACT_MIDDLE_NAME VARCHAR2 (60)
INVOICE_TO_CONTACT_LAST_NAME VARCHAR2 (150)
INVOICE_TO_ADDRESS1 VARCHAR2 (240)
INVOICE_TO_ADDRESS2 VARCHAR2 (240)
INVOICE_TO_ADDRESS3 VARCHAR2 (240)
INVOICE_TO_ADDRESS4 VARCHAR2 (240)
INVOICE_TO_COUNTRY_CODE VARCHAR2 (80)
INVOICE_TO_COUNTRY VARCHAR2 (60)
INVOICE_TO_CITY VARCHAR2 (60)
INVOICE_TO_POSTAL_CODE VARCHAR2 (60)
INVOICE_TO_STATE VARCHAR2 (60)
INVOICE_TO_PROVINCE VARCHAR2 (60)
INVOICE_TO_COUNTY VARCHAR2 (60)
RESOURCE_ID NUMBER

CONTRACT_TEMPLATE_ID NUMBER

CONTRACT_TEMPLATE_MAJOR_VER NUMBER

CONTRACT_REQUESTER_ID NUMBER

CONTRACT_APPROVAL_LEVEL VARCHAR2 (30)
PUBLISH_FLAG VARCHAR2 (1)
RESOURCE_GRP_ID NUMBER

SOLD_TO_PARTY_SITE_ID NUMBER

DISPLAY_ARITHMETIC_OPERATOR VARCHAR2 (30)
MAX_VERSION_FLAG VARCHAR2 (1)
QUOTE_TYPE VARCHAR2 (1)
QUOTE_DESCRIPTION VARCHAR2 (240)
CALL_BATCH_VALIDATION_FLAG VARCHAR2 (1)
CUST_PARTY_ID NUMBER

INVOICE_TO_CUST_PARTY_ID NUMBER

MINISITE_ID NUMBER

PRICING_STATUS_INDICATOR VARCHAR2 (1)
TAX_STATUS_INDICATOR VARCHAR2 (1)
PRICE_UPDATED_DATE DATE

TAX_UPDATED_DATE DATE

RECALCULATE_FLAG VARCHAR2 (1)
BATCH_PRICE_FLAG VARCHAR2 (1)
PRICE_REQUEST_ID NUMBER

CREDIT_UPDATE_DATE DATE

CUSTOMER_NAME_AND_TITLE VARCHAR2 (240)
CUSTOMER_SIGNATURE_DATE DATE

SUPPLIER_NAME_AND_TITLE VARCHAR2 (240)
SUPPLIER_SIGNATURE_DATE DATE

OBJECT_VERSION_NUMBER NUMBER

ASSISTANCE_REQUESTED VARCHAR2 (1)
ASSISTANCE_REASON_CODE VARCHAR2 (30)
AUTOMATIC_PRICE_FLAG VARCHAR2 (1)
AUTOMATIC_TAX_FLAG VARCHAR2 (1)
END_CUSTOMER_PARTY_ID NUMBER

END_CUSTOMER_PARTY_SITE_ID NUMBER

END_CUSTOMER_CUST_ACCOUNT_ID NUMBER

END_CUSTOMER_CUST_PARTY_ID NUMBER

ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
HEADER_PAYNOW_CHARGES NUMBER

Dependencies

[top of page]

APPS.ASO_QUOTE_PUB_QTE_HEADER_REC_ references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
APPS.ASO_QUOTE_PUB_QTE_HEADER_REC_ is referenced by following:

SchemaAPPS
PL/SQL PackageASO_QUOTE_EBIZAD - show dependent code
Package BodyASO_QUOTE_EBIZAD - show dependent code