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.AHL_UMP_PROCESSUNIT_PVT dependencies on OKC_K_LINES_B

Line 1087: FROM okc_k_headers_b okh, okc_k_lines_b okl

1083: CURSOR get_oks_line_end_dt1(p_contract_number IN VARCHAR2,
1084: p_contract_modifier IN VARCHAR2)
1085: IS
1086: SELECT trunc(min(okl.end_date)), trunc(okh.start_date)
1087: FROM okc_k_headers_b okh, okc_k_lines_b okl
1088: WHERE OKL.DNZ_CHR_ID = OKH.ID
1089: AND OKH.CONTRACT_NUMBER = p_contract_number
1090: AND OKH.CONTRACT_NUMBER_MODIFIER = p_contract_modifier
1091: GROUP BY OKH.ID, OKH.start_date;

Line 1096: FROM okc_k_headers_b okh, okc_k_lines_b okl

1092:
1093: CURSOR get_oks_line_end_dt2(p_contract_number IN VARCHAR2)
1094: IS
1095: SELECT trunc(min(okl.end_date)), trunc(okh.start_date)
1096: FROM okc_k_headers_b okh, okc_k_lines_b okl
1097: WHERE OKL.DNZ_CHR_ID = OKH.ID
1098: AND OKH.CONTRACT_NUMBER = p_contract_number
1099: GROUP BY OKH.ID, OKH.start_date;
1100: