VIEW: APPS.OKS_BUS_PROCESSES_V

Source

View Text - Preformatted

SELECT cleb.rowid row_id , cleb.id id , cleb.object_version_number object_version_number , cleb.cle_id coverage_cle_id , cleb.lse_id lse_id , cleb.line_number line_number , cleb.dnz_chr_id dnz_chr_id , buspr.id1 bus_process_id1 , buspr.id2 bus_process_id2 , buspr.name bus_process_name , cleb.start_date start_date , cleb.end_date end_date , cleb.attribute_category attribute_category , cleb.attribute1 attribute1 , cleb.attribute2 attribute2 , cleb.attribute3 attribute3 , cleb.attribute4 attribute4 , cleb.attribute5 attribute5 , cleb.attribute6 attribute6 , cleb.attribute7 attribute7 , cleb.attribute8 attribute8 , cleb.attribute9 attribute9 , cleb.attribute10 attribute10 , cleb.attribute11 attribute11 , cleb.attribute12 attribute12 , cleb.attribute13 attribute13 , cleb.attribute14 attribute14 , cleb.attribute15 attribute15 , cleb.created_by created_by , cleb.creation_date creation_date , cleb.last_updated_by last_updated_by , cleb.last_update_date last_update_date , cleb.last_update_login last_update_login from okc_k_lines_b cleb , okc_k_items citem , okx_bus_processes_v buspr , jtf_objects_b jtfob WHERE jtfob.object_code = 'OKX_BUSIPROC' and cleb.lse_id IN (3,16,21) and citem.cle_id = cleb.id and citem.jtot_object1_code = jtfob.object_code and buspr.id1 = citem.object1_id1 and buspr.id2 = citem.object1_id2

View Text - HTML Formatted

SELECT CLEB.ROWID ROW_ID
, CLEB.ID ID
, CLEB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CLEB.CLE_ID COVERAGE_CLE_ID
, CLEB.LSE_ID LSE_ID
, CLEB.LINE_NUMBER LINE_NUMBER
, CLEB.DNZ_CHR_ID DNZ_CHR_ID
, BUSPR.ID1 BUS_PROCESS_ID1
, BUSPR.ID2 BUS_PROCESS_ID2
, BUSPR.NAME BUS_PROCESS_NAME
, CLEB.START_DATE START_DATE
, CLEB.END_DATE END_DATE
, CLEB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CLEB.ATTRIBUTE1 ATTRIBUTE1
, CLEB.ATTRIBUTE2 ATTRIBUTE2
, CLEB.ATTRIBUTE3 ATTRIBUTE3
, CLEB.ATTRIBUTE4 ATTRIBUTE4
, CLEB.ATTRIBUTE5 ATTRIBUTE5
, CLEB.ATTRIBUTE6 ATTRIBUTE6
, CLEB.ATTRIBUTE7 ATTRIBUTE7
, CLEB.ATTRIBUTE8 ATTRIBUTE8
, CLEB.ATTRIBUTE9 ATTRIBUTE9
, CLEB.ATTRIBUTE10 ATTRIBUTE10
, CLEB.ATTRIBUTE11 ATTRIBUTE11
, CLEB.ATTRIBUTE12 ATTRIBUTE12
, CLEB.ATTRIBUTE13 ATTRIBUTE13
, CLEB.ATTRIBUTE14 ATTRIBUTE14
, CLEB.ATTRIBUTE15 ATTRIBUTE15
, CLEB.CREATED_BY CREATED_BY
, CLEB.CREATION_DATE CREATION_DATE
, CLEB.LAST_UPDATED_BY LAST_UPDATED_BY
, CLEB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CLEB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_K_LINES_B CLEB
, OKC_K_ITEMS CITEM
, OKX_BUS_PROCESSES_V BUSPR
, JTF_OBJECTS_B JTFOB
WHERE JTFOB.OBJECT_CODE = 'OKX_BUSIPROC'
AND CLEB.LSE_ID IN (3
, 16
, 21)
AND CITEM.CLE_ID = CLEB.ID
AND CITEM.JTOT_OBJECT1_CODE = JTFOB.OBJECT_CODE
AND BUSPR.ID1 = CITEM.OBJECT1_ID1
AND BUSPR.ID2 = CITEM.OBJECT1_ID2