DBA Data[Home] [Help]

APPS.OKI_REFRESH_PVT dependencies on OKC_GOVERNANCES

Line 2655: , okc_governances og -- 11510 Changes

2651: , gl_periods spd
2652: , gl_periods spd1 -- 11510 Changes
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

Line 3113: , okc_governances og -- From oki_pricing_rule

3109: , gl_periods spd
3110: , gl_periods spd1 -- 11510 Changes
3111: , okc_k_rel_objs ro
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