VIEW: APPS.OKI_SALES_CREDITS_V

Source

View Text - Preformatted

SELECT chr_id, cle_id, NVL2(cle_id, 'N','Y') header_yn, ctc_id salesrep_id, srep.name salesrep, SALES_CREDIT_TYPE_ID1, ct.name credit_type, PERCENT FROM OKC_K_HEADERS_B H,JTF_RS_SALESREPS SREP,OE_SALES_CREDIT_TYPES CT,OKS_K_SALES_CREDITS CR WHERE cr.sales_credit_type_id1 = ct.sales_credit_type_id and srep.salesrep_id = ctc_id and h.id = cr.chr_id and srep.org_id = h.authoring_org_id

View Text - HTML Formatted

SELECT CHR_ID
, CLE_ID
, NVL2(CLE_ID
, 'N'
, 'Y') HEADER_YN
, CTC_ID SALESREP_ID
, SREP.NAME SALESREP
, SALES_CREDIT_TYPE_ID1
, CT.NAME CREDIT_TYPE
, PERCENT
FROM OKC_K_HEADERS_B H
, JTF_RS_SALESREPS SREP
, OE_SALES_CREDIT_TYPES CT
, OKS_K_SALES_CREDITS CR
WHERE CR.SALES_CREDIT_TYPE_ID1 = CT.SALES_CREDIT_TYPE_ID
AND SREP.SALESREP_ID = CTC_ID
AND H.ID = CR.CHR_ID
AND SREP.ORG_ID = H.AUTHORING_ORG_ID