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_EXTWAR_UTIL_PVT dependencies on OKS_K_HEADERS_B

Line 2868: oks_k_headers_b ks,

2864: ,
2865: party.object1_id1 party_id
2866: FROM okc_k_items_v ki,
2867: okc_k_headers_b kh,
2868: oks_k_headers_b ks,
2869: okc_k_lines_v kl,
2870: oks_k_lines_b okl,
2871: okc_statuses_v st,
2872: okc_k_party_roles_b party

Line 5219: -- oks_k_headers_b rul

5215: -- Nvl(rul.est_rev_percent,0) percent,
5216: -- st.ste_code
5217: -- FROM okc_k_headers_b kh,
5218: -- okc_statuses_b st,
5219: -- oks_k_headers_b rul
5220: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5221: -- AND kh.scs_code in ('SERVICE','WARRANTY')
5222: -- AND kh.sts_code = st.code
5223: -- AND st.ste_code = 'ENTERED'

Line 5247: oks_k_headers_b rul,

5243: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5244: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5245: FROM okc_k_headers_b kh,
5246: okc_statuses_b st,
5247: oks_k_headers_b rul,
5248: (SELECT included_chr_id
5249: FROM okc_k_grpings
5250: START WITH cgp_parent_id = p_contract_group
5251: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp

Line 5270: oks_k_headers_b rul,

5266: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5267: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5268: FROM okc_k_headers_b kh,
5269: okc_statuses_b st,
5270: oks_k_headers_b rul,
5271: (SELECT included_chr_id
5272: FROM okc_k_grpings
5273: START WITH cgp_parent_id = p_contract_group
5274: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp

Line 5292: oks_k_headers_b rul,

5288: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5289: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5290: FROM okc_k_headers_b kh,
5291: okc_statuses_b st,
5292: oks_k_headers_b rul,
5293: (SELECT included_chr_id
5294: FROM okc_k_grpings
5295: START WITH cgp_parent_id = p_contract_group
5296: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp

Line 5314: oks_k_headers_b rul,

5310: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5311: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5312: FROM okc_k_headers_b kh,
5313: okc_statuses_b st,
5314: oks_k_headers_b rul,
5315: (SELECT included_chr_id
5316: FROM okc_k_grpings
5317: START WITH cgp_parent_id = p_contract_group
5318: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp