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_UTL_PVT dependencies on OKI_COV_PRD_LINES

Line 78: , oki_cov_prd_lines cpl

74: ) RETURN g_tactk_all_csr_row IS
75: SELECT NVL(SUM(cpl.base_price_negotiated), 0) value
76: , COUNT(DISTINCT(shd.chr_id)) contract_count
77: FROM oki_sales_k_hdrs shd
78: , oki_cov_prd_lines cpl
79: WHERE shd.chr_id = cpl.chr_id
80: AND cpl.sts_code = 'ACTIVE'
81: AND shd.date_signed <= p_start_date
82: AND shd.date_approved <= p_start_date

Line 101: , oki_cov_prd_lines cpl

97: SELECT NVL(SUM(cpl.base_price_negotiated), 0) value
98: , COUNT(DISTINCT cpl.chr_id) contract_count
99: , shd.authoring_org_id authoring_org_id
100: FROM oki_sales_k_hdrs shd
101: , oki_cov_prd_lines cpl
102: WHERE shd.chr_id = cpl.chr_id
103: AND cpl.sts_code = 'ACTIVE'
104: AND shd.date_signed <= p_start_date
105: AND shd.date_approved <= p_start_date