[Home] [Help]
View: OKX_OPP_HEADERS_V
View Text
SELECT ASH.LEAD_ID ID1
, '#' ID2
, ASH.LEAD_NUMBER NAME
, ASH.DESCRIPTION DESCRIPTION
, ASH.STATUS STATUS
, ASH.CUSTOMER_ID CUSTOMER_ID
, ASH.ADDRESS_ID ADDRESS_ID
, ASH.SALES_STAGE_ID SALES_STAGE_ID
, ASH.CURRENCY_CODE CURRENCY_CODE
, ASH.TOTAL_AMOUNT TOTAL_AMOUNT
, ASH.DECISION_DATE DECISION_DATE
, ASH.WIN_PROBABILITY WIN_PROBABILITY
, ASH.CLOSE_REASON CLOSE_REASON
, ASH.ORG_ID ORG_ID
FROM AS_LEADS_ALL ASH
Columns
| Name |
| ID1 |
| ID2 |
| NAME |
| DESCRIPTION |
| STATUS |
| CUSTOMER_ID |
| ADDRESS_ID |
| SALES_STAGE_ID |
| CURRENCY_CODE |
| TOTAL_AMOUNT |
| DECISION_DATE |
| WIN_PROBABILITY |
| CLOSE_REASON |
| ORG_ID |
APPS.OKX_OPP_HEADERS_V