DBA Data[Home] [Help]

APPS.OKL_CREDIT_PUB dependencies on OKL_CHECKLIST_DTLS_ALL

Line 247: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH

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

Line 723: from OKL_CHECKLIST_DTLS_ALL CLD, OKL_CHECKLISTS CLH

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