VIEW: APPS.OKI_HCREDIT_DTL_V

Source

View Text - Preformatted

SELECT h.chr_id , h.contract_number , h.contract_number_modifier , h.complete_k_number , cr.resource_id , cr.credit_type , cr.sales_credit_percent , cr.sales_group_id resource_group_id from oki_srm_006_v h , ( select chr_id , jtfrs.resource_id , ct.name credit_type , percent sales_credit_percent , jtfrs.org_id org_id , sales_group_id from oe_sales_credit_types ct , oks_k_sales_credits cr , jtf_rs_salesreps jtfrs where jtfrs.salesrep_id = cr.ctc_id and cr.sales_credit_type_id1 = ct.sales_credit_type_id and cr.cle_id is null ) cr WHERE h.chr_id = cr.chr_id(+) and h.authoring_org_id = cr.org_id(+)

View Text - HTML Formatted

SELECT H.CHR_ID
, H.CONTRACT_NUMBER
, H.CONTRACT_NUMBER_MODIFIER
, H.COMPLETE_K_NUMBER
, CR.RESOURCE_ID
, CR.CREDIT_TYPE
, CR.SALES_CREDIT_PERCENT
, CR.SALES_GROUP_ID RESOURCE_GROUP_ID
FROM OKI_SRM_006_V H
, ( SELECT CHR_ID
, JTFRS.RESOURCE_ID
, CT.NAME CREDIT_TYPE
, PERCENT SALES_CREDIT_PERCENT
, JTFRS.ORG_ID ORG_ID
, SALES_GROUP_ID
FROM OE_SALES_CREDIT_TYPES CT
, OKS_K_SALES_CREDITS CR
, JTF_RS_SALESREPS JTFRS
WHERE JTFRS.SALESREP_ID = CR.CTC_ID
AND CR.SALES_CREDIT_TYPE_ID1 = CT.SALES_CREDIT_TYPE_ID
AND CR.CLE_ID IS NULL ) CR
WHERE H.CHR_ID = CR.CHR_ID(+)
AND H.AUTHORING_ORG_ID = CR.ORG_ID(+)