DBA Data[Home] [Help]

APPS.OKI_REFRESH_PVT dependencies on OKS_K_LINES_B

Line 2666: FROM oks_k_lines_b okscle,okc_k_lines_b okccle

2662: /* 11510 Changes Start */
2663: , (SELECT okscle.dnz_chr_id
2664: , SUM (NVL(ubt_amount,0) + NVL(credit_amount,0) +
2665: NVL(suppressed_credit,0)) terminated_amount
2666: FROM oks_k_lines_b okscle,okc_k_lines_b okccle
2667: WHERE okccle.id = okscle.cle_id
2668: AND okccle.price_level_ind='Y'
2669: GROUP BY okscle.dnz_chr_id
2670: ) terminated

Line 3128: FROM oks_k_lines_b okscle,okc_k_lines_b okccle,oki_job_run_dtl jrd

3124: /* 11510 Changes Start */
3125: ,(SELECT okscle.dnz_chr_id /*+ leading(jrd) full(jrd) cardinality(jrd,1)*/
3126: , SUM (NVL(ubt_amount,0) + NVL(credit_amount,0) +
3127: NVL(suppressed_credit,0)) terminated_amount
3128: FROM oks_k_lines_b okscle,okc_k_lines_b okccle,oki_job_run_dtl jrd
3129: WHERE okccle.id = okscle.cle_id
3130: AND okscle.dnz_chr_id = jrd.chr_id
3131: AND jrd.job_run_id = l_job_run_id
3132: AND jrd.action_flag = 'I'