243: --start modified abhsaxen for performance SQLID 20562590
244: select cld.todo_item_code,
245: cld.function_id,
246: clh.checklist_type
247: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH
248: where cld.ckl_id = clh.id
249: and exists (select 1
250: from okl_checklists chlidren
251: where chlidren.id = cld.ckl_id
719: --start modified abhsaxen for performance SQLID 20562606
720: select cld.todo_item_code,
721: cld.function_id,
722: clh.checklist_type
723: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH
724: where cld.ckl_id = clh.id
725: and exists (select 1
726: from okl_checklists chlidren
727: where chlidren.id = cld.ckl_id