APPS.OKI_REFRESH_PVT dependencies on OKC_OPERATION_LINES

Line 2657: FROM okc_operation_lines ol

2653: , okc_k_rel_objs ro
2654: , okx_order_headers_v oh
2655: , okc_governances og -- 11510 Changes
2656: , ( SELECT ol.subject_chr_id, decode(count(1),0,'Y','N') is_new_yn
2657: FROM okc_operation_lines ol
2658: WHERE 1 = 1
2659: AND ol.object_chr_id is not null
2660: GROUP BY ol.subject_chr_id
2661: ) r

Line 3116: FROM okc_operation_lines ol, oki_job_run_dtl jrd

3112: , okx_order_headers_v oh
3113: , okc_governances og -- From oki_pricing_rule
3114: , ( SELECT /*+ leading(jrd) full(jrd) cardinality(jrd,1)*/
3115: ol.subject_chr_id, decode(count(1),0,'Y','N') is_new_yn
3116: FROM okc_operation_lines ol, oki_job_run_dtl jrd
3117: WHERE 1 = 1
3118: AND jrd.job_run_id = l_job_run_id
3119: AND jrd.action_flag = 'I'
3120: AND ol.subject_chr_id = jrd.chr_id

Line 4159: ,(select distinct object_cle_id cle_id from okc_operation_lines

4155: ,csi_item_instances cii
4156: ,okc_statuses_b sts
4157: /*11510 changes added*/
4158: ,gl_periods epd
4159: ,(select distinct object_cle_id cle_id from okc_operation_lines
4160: where active_yn = 'Y' ) exp
4161: where 1 = 1
4162: and cii.instance_id = to_number(cim.object1_id1)
4163: and cim.cle_id = cle.id

Line 4546: ,(select distinct object_cle_id cle_id from okc_operation_lines

4542: , okc_statuses_b sts
4543: , oki_job_run_dtl jrd
4544: /*11510 changes added*/
4545: , gl_periods epd
4546: ,(select distinct object_cle_id cle_id from okc_operation_lines
4547: where active_yn = 'Y' ) exp --Bug Fix 3469671 code changes
4548: WHERE
4549: cii.instance_id = to_number(cim.object1_id1)
4550: AND exp.cle_id(+) = cle.id --Bug Fix 3469671 code changes