VIEW: APPS.OKS_SALES_COMPENSATION_V

Source

View Text - Preformatted

SELECT sr.SALESREP_NUMBER salesrep_number, sr.name salesrep_name, pty.name customer, okh.date_approved date_contract_approved, okh.contract_number contract_number, okh.start_date contract_start_date, okh.ESTIMATED_AMOUNT estimated_amount from jtf_rs_salesreps sr ,oks_k_sales_credits sc ,okx_parties_v pty ,okc_k_party_roles_b op1 ,okc_k_headers_b okh WHERE okh.sts_code = 'ENTERED' and okh.id = op1.dnz_chr_id and op1.cle_id is null and op1.rle_code = 'CUSTOMER' and pty.id1 = op1.object1_id1 and pty.id2 = '#' and okh.id = sc.chr_id and sc.cle_id is null and sc.ctc_id = sr.salesrep_id

View Text - HTML Formatted

SELECT SR.SALESREP_NUMBER SALESREP_NUMBER
, SR.NAME SALESREP_NAME
, PTY.NAME CUSTOMER
, OKH.DATE_APPROVED DATE_CONTRACT_APPROVED
, OKH.CONTRACT_NUMBER CONTRACT_NUMBER
, OKH.START_DATE CONTRACT_START_DATE
, OKH.ESTIMATED_AMOUNT ESTIMATED_AMOUNT
FROM JTF_RS_SALESREPS SR
, OKS_K_SALES_CREDITS SC
, OKX_PARTIES_V PTY
, OKC_K_PARTY_ROLES_B OP1
, OKC_K_HEADERS_B OKH
WHERE OKH.STS_CODE = 'ENTERED'
AND OKH.ID = OP1.DNZ_CHR_ID
AND OP1.CLE_ID IS NULL
AND OP1.RLE_CODE = 'CUSTOMER'
AND PTY.ID1 = OP1.OBJECT1_ID1
AND PTY.ID2 = '#'
AND OKH.ID = SC.CHR_ID
AND SC.CLE_ID IS NULL
AND SC.CTC_ID = SR.SALESREP_ID