VIEW: APPS.OKX_OPP_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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