VIEW: APPS.OKS_ENT_HDR_SUMMARY_V

Source

View Text - Preformatted

SELECT HDR.ID CONTRACT_ID , HDR.CONTRACT_NUMBER CONTRACT_NUMBER , HDR.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER , HDR.ESTIMATED_AMOUNT CONTRACT_AMOUNT , HDR.CURRENCY_CODE CURRENCY_CODE , HDR.STS_CODE CONTRACT_STATUS_CODE , HDR.START_DATE START_DATE_ACTIVE , HDR.END_DATE END_DATE_ACTIVE , PTY.OBJECT1_ID1 PARTY_ID FROM OKC_K_HEADERS_ALL_B HDR , OKC_K_PARTY_ROLES_B PTY , OKC_SUBCLASSES_B CLS WHERE hdr.template_yn ='N' AND cls.code in ('SERVICE','WARRANTY','SUBSCRIPTION') AND hdr.scs_code = cls.code AND hdr.id = pty.chr_id AND pty.rle_code in ('CUSTOMER', 'SUBSCRIBER') AND pty.jtot_object1_code = 'OKX_PARTY'

View Text - HTML Formatted

SELECT HDR.ID CONTRACT_ID
, HDR.CONTRACT_NUMBER CONTRACT_NUMBER
, HDR.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, HDR.ESTIMATED_AMOUNT CONTRACT_AMOUNT
, HDR.CURRENCY_CODE CURRENCY_CODE
, HDR.STS_CODE CONTRACT_STATUS_CODE
, HDR.START_DATE START_DATE_ACTIVE
, HDR.END_DATE END_DATE_ACTIVE
, PTY.OBJECT1_ID1 PARTY_ID
FROM OKC_K_HEADERS_ALL_B HDR
, OKC_K_PARTY_ROLES_B PTY
, OKC_SUBCLASSES_B CLS
WHERE HDR.TEMPLATE_YN ='N'
AND CLS.CODE IN ('SERVICE'
, 'WARRANTY'
, 'SUBSCRIPTION')
AND HDR.SCS_CODE = CLS.CODE
AND HDR.ID = PTY.CHR_ID
AND PTY.RLE_CODE IN ('CUSTOMER'
, 'SUBSCRIBER')
AND PTY.JTOT_OBJECT1_CODE = 'OKX_PARTY'