VIEW: APPS.OKI_SCREDIT_DTL_V

Source

View Text - Preformatted

SELECT S.SLE_ID , S.CONTRACT_NUMBER , S.CONTRACT_NUMBER_MODIFIER , S.COMPLETE_K_NUMBER , jtfrs.RESOURCE_ID , CT.NAME CREDIT_TYPE , PERCENT SALES_CREDIT_PERCENT , SALES_GROUP_ID RESOURCE_GROUP_ID FROM OKI_SRM_005_V S , OE_SALES_CREDIT_TYPES CT , OKS_K_SALES_CREDITS CR , JTF_RS_SALESREPS jtfrs WHERE CR.SALES_CREDIT_TYPE_ID1 = CT.SALES_CREDIT_TYPE_ID AND S.SLE_ID = CR.CLE_ID AND jtfrs.SALESREP_ID = CR.CTC_ID AND jtfrs.ORG_ID = S.AUTHORING_ORG_ID

View Text - HTML Formatted

SELECT S.SLE_ID
, S.CONTRACT_NUMBER
, S.CONTRACT_NUMBER_MODIFIER
, S.COMPLETE_K_NUMBER
, JTFRS.RESOURCE_ID
, CT.NAME CREDIT_TYPE
, PERCENT SALES_CREDIT_PERCENT
, SALES_GROUP_ID RESOURCE_GROUP_ID
FROM OKI_SRM_005_V S
, OE_SALES_CREDIT_TYPES CT
, OKS_K_SALES_CREDITS CR
, JTF_RS_SALESREPS JTFRS
WHERE CR.SALES_CREDIT_TYPE_ID1 = CT.SALES_CREDIT_TYPE_ID
AND S.SLE_ID = CR.CLE_ID
AND JTFRS.SALESREP_ID = CR.CTC_ID
AND JTFRS.ORG_ID = S.AUTHORING_ORG_ID