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