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 5493: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_B';

5489: P_Num_Workers in number)
5490: IS
5491: l_worker_id number;
5492: l_product varchar2(30) := 'OKC';
5493: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_B';
5494: l_update_name varchar2(30) := 'OKCLNUPG_CP';
5495: l_status varchar2(30);
5496: l_industry varchar2(30);
5497: l_retstatus boolean;

Line 5558: from okc_k_headers_all_b hdr,

5554: / (trunc (months_between (cle.end_date, cle.start_date) / 12) + 1)
5555: / (cle.end_date - cle.start_date + 1)
5556: ELSE cle.annualized_factor
5557: end new_annualized_factor
5558: from okc_k_headers_all_b hdr,
5559: okc_k_lines_b cle
5560: where hdr.rowid between l_start_rowid and l_end_rowid
5561: and hdr.id = cle.dnz_chr_id
5562: and hdr.scs_code in ('SERVICE', 'WARRANTY', 'SUBSCRIPTION'))

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

5593: P_Num_Workers in number)
5594: IS
5595: l_worker_id number;
5596: l_product varchar2(30) := 'OKC';
5597: l_table_name varchar2(30) := 'OKC_K_HEADERS_ALL_BH';
5598: l_update_name varchar2(30) := 'OKCLNUPH_CP';
5599: l_status varchar2(30);
5600: l_industry varchar2(30);
5601: l_retstatus boolean;

Line 5661: from okc_k_headers_all_bh hdr,

5657: / (trunc (months_between (cle.end_date, cle.start_date) / 12) + 1)
5658: / (cle.end_date - cle.start_date + 1)
5659: ELSE cle.annualized_factor
5660: end new_annualized_factor
5661: from okc_k_headers_all_bh hdr,
5662: okc_k_lines_bh cle
5663: where hdr.rowid between l_start_rowid and l_end_rowid
5664: and hdr.id = cle.dnz_chr_id
5665: and hdr.major_version = cle.major_version