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