View: OKC_KEXP_REPORT_V

Product:	OKC - Contracts Core
Description:	This view is registered as a source for the Discoverer Folder and Workbook 'Expired Contracts' . This view is a multiple table joins, primarily sourced from the Contracts headers view 'OKC_K_HEADERS_V' for the matched rows that are availble
Implementation/DBA Data:	APPS.OKC_KEXP_REPORT_V

View Text

SELECT CHRV.CONTRACT_NUMBER
, CHRV.CURRENCY_CODE CURRENCY
, CHRV.ESTIMATED_AMOUNT AMOUNT
, CHRV.START_DATE
, CHRV.END_DATE
, OKC_UTIL.GET_NAME_FROM_JTFV( KPR.JTOT_OBJECT1_CODE
, KPR.OBJECT1_ID1
, KPR.OBJECT1_ID2) CUSTOMER
, OKC_KEXP_PVT.GET_SALESREP_NAME( KCON.OBJECT1_ID1
, KCON.OBJECT1_ID2) SALESREP
, JT.NAME TERRITORY
, KEXP.REPORT_ID
, KVER.LAST_UPDATE_DATE
FROM OKC_KEXP_REPORT KEXP
, OKC_K_HEADERS_B CHRV
, OKC_K_PARTY_ROLES_B KPR
, OKC_K_VERS_NUMBERS KVER
, JTF_TERR_ALL JT
, JTF_TERR_QUAL_ALL JTQ
, JTF_TERR_VALUES_ALL JTV
, OKC_CONTACTS KCON
WHERE CHRV.ID = KPR.DNZ_CHR_ID
AND CHRV.ID = KPR.CHR_ID
AND KCON.DNZ_CHR_ID = CHRV.ID
AND CHRV.ROWID = KEXP.CONTRACT_HEADER_ROWID
AND KPR.RLE_CODE = 'CUSTOMER'
AND KPR.JTOT_OBJECT1_CODE = 'OKX_PARTY'
AND KCON.JTOT_OBJECT1_CODE = 'OKX_SALEPERS'
AND KCON.CRO_CODE = 'SUP_SALES'
AND CHRV.CHR_ID_RENEWED IS NULL
AND TO_CHAR(JTV.LOW_VALUE_CHAR_ID) = KPR.OBJECT1_ID1
AND JTV.TERR_QUAL_ID = JTQ.TERR_QUAL_ID
AND JTQ.TERR_ID = JT.TERR_ID
AND CHRV.ID = KVER.CHR_ID

Columns