Product: | OKS - Service Contracts |
---|---|
Description: | This View is Used for Service Contracts Summary Report |
Implementation/DBA Data: | APPS.OKS_REPNAME_V |
SELECT ( SELECT OBJECT1_ID1
FROM OKC_CONTACTS_V
WHERE CRO_CODE = NVL(FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE')
, 'SUP_SALES')
AND CPL_ID = (SELECT ID
FROM OKC_K_PARTY_ROLES_V PARTY
WHERE PARTY.DNZ_CHR_ID = K.ID
AND PARTY.CLE_ID IS NULL
AND PARTY.RLE_CODE = 'VENDOR'
AND ROWNUM < 2)
AND ROWNUM < 2) 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.AUTHORING_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
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