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.OKC_EXP_DATE_ASMBLR_PVT dependencies on OKC_K_HEADERS_B

Line 35: --Modified the where clause toavoid the FTS on OKC_K_HEADERS_B

31: l_acn_id NUMBER;
32:
33: --Get all the contracts that are expiring from the last rundate
34: --of the date assembler concurrent program for a given condition
35: --Modified the where clause toavoid the FTS on OKC_K_HEADERS_B
36:
37: CURSOR k1_csr(p_chr_id IN NUMBER, p_variance IN NUMBER, p_last_rundate IN DATE)
38: IS
39: SELECT /*+ leading(khr) use_nl(khr cls) */ khr.id k_id, -- Bug 5012601 Added hint to avoid FTS

Line 48: FROM okc_k_headers_b khr,

44: khr.scs_code k_subclass,
45: khr.estimated_amount k_estimated_amount,
46: khr.sts_code,
47: khr.authoring_org_id
48: FROM okc_k_headers_b khr,
49: okc_subclasses_b cls
50: WHERE (khr.id = p_chr_id OR p_chr_id IS NULL)
51: AND khr.scs_code = cls.code
52: AND khr.end_date BETWEEN (p_variance + trunc(p_last_rundate) + 1)

Line 311: FROM okc_k_headers_b khr,

307: khr.scs_code k_subclass,
308: khr.estimated_amount k_estimated_amount,
309: khr.sts_code,
310: khr.authoring_org_id
311: FROM okc_k_headers_b khr,
312: okc_subclasses_b cls,
313: okc_statuses_b sts ,
314: okc_k_lines_b kln
315: WHERE