[Home] [Help]
View: OKC_REL_OBJ_QUOTE_HEADERS_V
View Text
SELECT HDR.NAME QUOTE_NUMBER
, HDR.DESCRIPTION QUOTE_DESCRIPTION
, JR.RESOURCE_NAME SALES_PERSON
, HDR.TOTAL_QUOTE_PRICE TOTAL_QUOTE_PRICE
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.JTOT_OBJECT1_CODE
, REL.CHR_ID CHR_ID
, HDR.CURRENCY_CODE CURRENCY
FROM JTF_RS_RESOURCE_EXTNS_VL JR
, OKX_QUOTE_HEADERS_V HDR
, OKC_K_REL_OBJS REL
WHERE HDR.ID1 = REL.OBJECT1_ID1
AND HDR.RESOURCE_ID = JR.RESOURCE_ID(+)
Columns
| Name |
| QUOTE_NUMBER |
| QUOTE_DESCRIPTION |
| SALES_PERSON |
| TOTAL_QUOTE_PRICE |
| OBJECT1_ID1 |
| JTOT_OBJECT_CODE |
| CHR_ID |
| CURRENCY |
APPS.OKC_REL_OBJ_QUOTE_HEADERS_V