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 2822: oks_k_headers_b ks,

2818: ,
2819: party.object1_id1 party_id
2820: FROM okc_k_items_v ki,
2821: okc_k_headers_b kh,
2822: oks_k_headers_b ks,
2823: okc_k_lines_v kl,
2824: oks_k_lines_b okl,
2825: okc_statuses_v st,
2826: okc_k_party_roles_b party

Line 5173: -- oks_k_headers_b rul

5169: -- Nvl(rul.est_rev_percent,0) percent,
5170: -- st.ste_code
5171: -- FROM okc_k_headers_b kh,
5172: -- okc_statuses_b st,
5173: -- oks_k_headers_b rul
5174: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5175: -- AND kh.scs_code in ('SERVICE','WARRANTY')
5176: -- AND kh.sts_code = st.code
5177: -- AND st.ste_code = 'ENTERED'

Line 5201: oks_k_headers_b rul,

5197: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5198: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5199: FROM okc_k_headers_b kh,
5200: okc_statuses_b st,
5201: oks_k_headers_b rul,
5202: (SELECT included_chr_id
5203: FROM okc_k_grpings
5204: START WITH cgp_parent_id = p_contract_group
5205: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp

Line 5224: oks_k_headers_b rul,

5220: SELECT kh.currency_code, kh.sts_code, kh.ID contract_id,
5221: NVL (rul.est_rev_percent, 0) PERCENT, st.ste_code
5222: FROM okc_k_headers_b kh,
5223: okc_statuses_b st,
5224: oks_k_headers_b rul,
5225: (SELECT included_chr_id
5226: FROM okc_k_grpings
5227: START WITH cgp_parent_id = p_contract_group
5228: CONNECT BY cgp_parent_id = PRIOR included_cgp_id) grp

Line 5246: oks_k_headers_b rul,

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

Line 5268: oks_k_headers_b rul,

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