eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OKC_KEXP_REPORT_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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