[Home] [Help]
View: OKC_REL_OBJ_OPP_HEADERS_V
View Text
SELECT HDR.NAME OPP_NUMBER
, HDR.DESCRIPTION OPP_DESCRIPTION
, HDR.TOTAL_AMOUNT TOTAL_AMOUNT
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.JTOT_OBJECT1_CODE
, REL.CHR_ID CHR_ID
, HDR.CURRENCY_CODE CURRENCY
, HDR.WIN_PROBABILITY WIN_PROBABILITY
, HDR.STATUS STATUS
FROM OKX_OPP_HEADERS_V HDR
, OKC_K_REL_OBJS REL
WHERE HDR.ID1 = REL.OBJECT1_ID1
Columns
| Name |
| OPP_NUMBER |
| OPP_DESCRIPTION |
| TOTAL_AMOUNT |
| OBJECT1_ID1 |
| JTOT_OBJECT_CODE |
| CHR_ID |
| CURRENCY |
| WIN_PROBABILITY |
| STATUS |
APPS.OKC_REL_OBJ_OPP_HEADERS_V