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.OKS_SETUP_UTIL_PUB dependencies on OKC_K_HEADERS_ALL_B

Line 5502: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_B';

5498: P_Num_Workers in number)
5499: IS
5500: l_worker_id number;
5501: l_product varchar2(30) := 'OKC';
5502: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_B';
5503: l_update_name varchar2(30) := 'OKCLNUPG_CP';
5504: l_status varchar2(30);
5505: l_industry varchar2(30);
5506: l_retstatus boolean;

Line 5567: from okc_k_headers_all_b hdr,

5563: / (trunc (months_between (cle.end_date, cle.start_date) / 12) + 1)
5564: / (cle.end_date - cle.start_date + 1)
5565: ELSE cle.annualized_factor
5566: end new_annualized_factor
5567: from okc_k_headers_all_b hdr,
5568: okc_k_lines_b cle
5569: where hdr.rowid between l_start_rowid and l_end_rowid
5570: and hdr.id = cle.dnz_chr_id
5571: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))

Line 5606: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_BH';

5602: P_Num_Workers in number)
5603: IS
5604: l_worker_id number;
5605: l_product varchar2(30) := 'OKC';
5606: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_BH';
5607: l_update_name varchar2(30) := 'OKCLNUPH_CP';
5608: l_status varchar2(30);
5609: l_industry varchar2(30);
5610: l_retstatus boolean;

Line 5670: from okc_k_headers_all_bh hdr,

5666: / (trunc (months_between (cle.end_date, cle.start_date) / 12) + 1)
5667: / (cle.end_date - cle.start_date + 1)
5668: ELSE cle.annualized_factor
5669: end new_annualized_factor
5670: from okc_k_headers_all_bh hdr,
5671: okc_k_lines_bh cle
5672: where hdr.rowid between l_start_rowid and l_end_rowid
5673: and hdr.id = cle.dnz_chr_id
5674: and hdr.major_version = cle.major_version