[Home] [Help]
View: ICX_SAVEDORDER_V
Product: | ICX - Oracle iProcurement |
Description: | Saved Orders View - Retrofitted |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT ASQ.CONTACT_ID
, ASQ.CREATED_BY
, ASQ.QUOTE_ID
, ASQ.QUOTE_NUMBER
, ASQ.QUOTE_NAME
, ASQ.CREATION_DATE
, ASQ.ORDER_DATE
, ASQ.QUOTE_STATUS
, ASQ.CUSTOMER_ID
, ASQ.ORG_ID
FROM AS_QUOTES ASQ
, AS_QUOTE_LINES ASQL
WHERE ASQ.QUOTE_STATUS = 'DRAFT'
AND ASQ.QUOTE_ID = ASQL.QUOTE_ID
Columns
Name |
CONTACT_ID |
CREATED_BY |
QUOTE_ID |
QUOTE_NUMBER |
QUOTE_NAME |
CREATION_DATE |
NEED_BY_DATE |
QUOTE_STATUS |
CUSTOMER_ID |
ORG_ID |