[Home] [Help] [Dependency Information]

TABLE: OSM.AS_QUOTES_ALL

Object Details

Object Name:	AS_QUOTES_ALL
Object Type:	TABLE
Owner:	OSM
FND Design Data:	AS.AS_QUOTES_ALL
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AS_QUOTES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	QUOTE_ID
AS_QUOTES_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	QUOTE_NUMBER QUOTE_VERSION ORG_ID
AS_QUOTES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	CUSTOMER_ID

Columns

Query Text

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

SELECT QUOTE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      EMPLOYEE_PERSON_ID
,      PRICE_LIST_ID
,      QUOTE_STATUS
,      CUSTOMER_ID
,      ADDRESS_ID
,      QUOTE_NAME
,      QUOTE_NUMBER
,      QUOTE_VERSION
,      CURRENCY_CODE
,      TOTAL_QUOTE_PRICE
,      CONTACT_ID
,      DESCRIPTION
,      ORIGINAL_QUOTE_ID
,      QUOTE_START_DATE
,      QUOTE_END_DATE
,      QUOTE_LETTER_ID
,      LEAD_ID
,      PROMOTION_ID
,      PURGE_ALLOWED_FLAG
,      ORDER_DATE
,      ORDER_TYPE_ID
,      HEADER_ID
,      TAX_EXEMPT_NUM
,      TAX_EXEMPT_REASON_CODE
,      TOTAL_LIST_PRICE
,      TOTAL_DISCOUNT_AMOUNT
,      TOTAL_DISCOUNT_PERCENT
,      DISCOUNT_MTHD_CODE
,      DISCOUNT_ID
,      TOTAL_TAX
,      APPROVAL_PERSON_ID
,      APPROVAL_FLAG
,      APPROVAL_DATE
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      INVOICE_TO_SITE_USE_ID
,      INVOICE_TO_CONTACT_ID
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      AGREEMENT_ID
,      PAYMENT_TERM_ID
,      PURCHASE_ORDER_NUM
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      FOB_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      EXCHANGE_RATE
,      EXCHANGE_TYPE_CODE
,      EXCHANGE_RATE_DATE
,      PAYMENT_TYPE_CODE
,      PAYMENT_AMOUNT
,      CHECK_NUMBER
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SALES_CHANNEL_CODE
,      TAX_EXEMPT_FLAG
,      ORG_ID
,      NEED_BY_DATE
,      SHIPPING_COST
FROM OSM.AS_QUOTES_ALL;

Dependencies

[top of page]

OSM.AS_QUOTES_ALL does not reference any database object

OSM.AS_QUOTES_ALL is referenced by following:

OSM

AS_QUOTES_ALL#