[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 |