eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_REFRESH_PVT dependencies on OKC_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 2743: okc_k_lines_b cle

2739: SELECT -SUM(bcl.amount),
2740: -SUM(bcl.amount) * shd.sob_contract_amount/ DECODE(shd.contract_amount,0,NULL,shd.contract_amount),
2741: -SUM(bcl.amount) * shd.base_contract_amount/ DECODE(shd.contract_amount,0,NULL,shd.contract_amount)
2742: FROM oks_bill_cont_lines bcl,
2743: okc_k_lines_b cle
2744: WHERE bcl.bill_action = 'TR'
2745: AND cle.id = bcl.cle_id
2746: AND cle.chr_id = shd.chr_id )
2747: WHERE shd.date_terminated IS NOT NULL;

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'

Line 3210: okc_k_lines_b cle

3206: SELECT -SUM(bcl.amount),
3207: -SUM(bcl.amount) * shd.sob_contract_amount/ DECODE(shd.contract_amount,0,NULL,shd.contract_amount),
3208: -SUM(bcl.amount) * shd.base_contract_amount/ DECODE(shd.contract_amount,0,NULL,shd.contract_amount)
3209: FROM oks_bill_cont_lines bcl,
3210: okc_k_lines_b cle
3211: WHERE bcl.bill_action = 'TR'
3212: AND cle.id = bcl.cle_id
3213: AND cle.chr_id = shd.chr_id )
3214: WHERE shd.date_terminated IS NOT NULL

Line 3523: okc_k_lines_b cle

3519: ,cle.attribute15
3520: ,cle.bill_to_site_use_id -- 11510 Changes
3521: ,cle.ship_to_site_use_id -- 11510 Changes
3522: FROM
3523: okc_k_lines_b cle
3524: ,oki_sales_k_hdrs shd
3525: ,okc_k_items cim
3526: ,okc_statuses_b sts
3527: ,oki_job_run_dtl jrd -- 11510 Changes

Line 3815: okc_k_lines_b cle

3811: , cle.attribute15
3812: , cle.bill_to_site_use_id -- 11510 Changes
3813: , cle.ship_to_site_use_id -- 11510 Changes
3814: FROM
3815: okc_k_lines_b cle
3816: , oki_sales_k_hdrs shd
3817: , okc_k_items cim
3818: , okc_statuses_b sts
3819: , oki_job_run_dtl jrd

Line 4153: ,okc_k_lines_b cle

4149: from
4150: oki_sold_itm_lines sil
4151: /*11510 changes added*/
4152: ,oki_job_run_dtl jrd
4153: ,okc_k_lines_b cle
4154: ,okc_k_items cim
4155: ,csi_item_instances cii
4156: ,okc_statuses_b sts
4157: /*11510 changes added*/

Line 4538: okc_k_lines_b cle

4534: ,'N')--if the contract is not expired 'N'
4535: is_exp_not_renewed_yn
4536: --Bug Fix 3469671 code changes-------------------------------------------------
4537: FROM
4538: okc_k_lines_b cle
4539: , oki_sold_itm_lines sil
4540: , okc_k_items cim
4541: , csi_item_instances cii
4542: , okc_statuses_b sts