VIEW: APPS.OKS_REPNAME_V

Source

View Text - Preformatted

SELECT con.Object1_id1 Rep_name ,px.party_id Customer_id ,px.party_name Customer_name ,px.party_number Customer_number ,k.id Contract_id ,k.Contract_number Contract_number ,k.Contract_number_modifier Contract_modifier ,k.sts_code status_code ,st.meaning status_meaning ,K.start_date start_date ,k.end_date end_date ,k.estimated_amount total_value ,k.last_update_date last_update_date ,st.ste_code Status_type ,k.org_id org_id ,k.currency_code From Okc_k_headers_b K ,Okc_k_party_roles_b pr ,Hz_parties px ,Okc_statuses_v st ,Okc_contacts_v con ,OKC_K_PARTY_ROLES_V party WHERE pr.dnz_chr_id = k.id and pr.cle_id is null and px.party_id = pr.object1_id1 and k.scs_code in ('SERVICE','WARRANTY') and pr.rle_code = 'CUSTOMER' and pr.chr_id = k.id and st.code = k.sts_code and party.dnz_chr_id = k.id and party.cle_id Is Null and party.rle_code = 'VENDOR' and con.cpl_id = party.ID and con.ID = OKS_EXTWAR_UTIL_PVT.active_salesrep(k.ID,party.ID, k.authoring_org_id) and con.cro_code = NVL(FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE'), 'SUP_SALES')

View Text - HTML Formatted

SELECT CON.OBJECT1_ID1 REP_NAME
, PX.PARTY_ID CUSTOMER_ID
, PX.PARTY_NAME CUSTOMER_NAME
, PX.PARTY_NUMBER CUSTOMER_NUMBER
, K.ID CONTRACT_ID
, K.CONTRACT_NUMBER CONTRACT_NUMBER
, K.CONTRACT_NUMBER_MODIFIER CONTRACT_MODIFIER
, K.STS_CODE STATUS_CODE
, ST.MEANING STATUS_MEANING
, K.START_DATE START_DATE
, K.END_DATE END_DATE
, K.ESTIMATED_AMOUNT TOTAL_VALUE
, K.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ST.STE_CODE STATUS_TYPE
, K.ORG_ID ORG_ID
, K.CURRENCY_CODE
FROM OKC_K_HEADERS_B K
, OKC_K_PARTY_ROLES_B PR
, HZ_PARTIES PX
, OKC_STATUSES_V ST
, OKC_CONTACTS_V CON
, OKC_K_PARTY_ROLES_V PARTY
WHERE PR.DNZ_CHR_ID = K.ID
AND PR.CLE_ID IS NULL
AND PX.PARTY_ID = PR.OBJECT1_ID1
AND K.SCS_CODE IN ('SERVICE'
, 'WARRANTY')
AND PR.RLE_CODE = 'CUSTOMER'
AND PR.CHR_ID = K.ID
AND ST.CODE = K.STS_CODE
AND PARTY.DNZ_CHR_ID = K.ID
AND PARTY.CLE_ID IS NULL
AND PARTY.RLE_CODE = 'VENDOR'
AND CON.CPL_ID = PARTY.ID
AND CON.ID = OKS_EXTWAR_UTIL_PVT.ACTIVE_SALESREP(K.ID
, PARTY.ID
, K.AUTHORING_ORG_ID)
AND CON.CRO_CODE = NVL(FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE')
, 'SUP_SALES')