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(+)
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(+)
|
|
|