VIEW: APPS.OKI_RENEW_RELS_V

Source

View Text - Preformatted

SELECT schr.id ,schr.sts_code ,ssts1.ste_code ,scle.id ,scle.sts_code ,ssts2.ste_code ,tchr.id ,tchr.sts_code ,tsts1.ste_code ,tcle.id ,tcle.sts_code ,tsts2.ste_code FROM OKC_CLASS_OPERATIONS COP,OKC_K_HEADERS_B TCHR,OKC_K_LINES_B TCLE,OKC_OPERATION_INSTANCES OIE,OKC_OPERATION_LINES OLE,OKC_K_HEADERS_B SCHR,OKC_K_LINES_B SCLE,OKC_STATUSES_B TSTS1,OKC_STATUSES_B TSTS2,OKC_STATUSES_B SSTS1,OKC_STATUSES_B SSTS2 WHERE cop.opn_code in ('RENEWAL','REN_CON') and cop.id = oie.cop_id and ole.process_flag = 'P' and ole.oie_id = oie.id and tchr.id = ole.subject_chr_id and tcle.id = ole.subject_cle_id and tsts1.code = tchr.sts_code and tsts2.code = tcle.sts_code and schr.id = ole.object_chr_id and scle.id = ole.object_cle_id and ssts1.code = schr.sts_code and ssts2.code = scle.sts_code

View Text - HTML Formatted

SELECT SCHR.ID
, SCHR.STS_CODE
, SSTS1.STE_CODE
, SCLE.ID
, SCLE.STS_CODE
, SSTS2.STE_CODE
, TCHR.ID
, TCHR.STS_CODE
, TSTS1.STE_CODE
, TCLE.ID
, TCLE.STS_CODE
, TSTS2.STE_CODE
FROM OKC_CLASS_OPERATIONS COP
, OKC_K_HEADERS_B TCHR
, OKC_K_LINES_B TCLE
, OKC_OPERATION_INSTANCES OIE
, OKC_OPERATION_LINES OLE
, OKC_K_HEADERS_B SCHR
, OKC_K_LINES_B SCLE
, OKC_STATUSES_B TSTS1
, OKC_STATUSES_B TSTS2
, OKC_STATUSES_B SSTS1
, OKC_STATUSES_B SSTS2
WHERE COP.OPN_CODE IN ('RENEWAL'
, 'REN_CON')
AND COP.ID = OIE.COP_ID
AND OLE.PROCESS_FLAG = 'P'
AND OLE.OIE_ID = OIE.ID
AND TCHR.ID = OLE.SUBJECT_CHR_ID
AND TCLE.ID = OLE.SUBJECT_CLE_ID
AND TSTS1.CODE = TCHR.STS_CODE
AND TSTS2.CODE = TCLE.STS_CODE
AND SCHR.ID = OLE.OBJECT_CHR_ID
AND SCLE.ID = OLE.OBJECT_CLE_ID
AND SSTS1.CODE = SCHR.STS_CODE
AND SSTS2.CODE = SCLE.STS_CODE