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 OKC_K_HEADERS_B

Line 411: FROM OKC_K_HEADERS_B CHR

407: -- Fix for bug# 4690982
408:
409: CURSOR c_Chr(c_CHR_ID IN NUMBER) IS
410: SELECT Id
411: FROM OKC_K_HEADERS_B CHR
412: ,OKC_STATUSES_B CST
413: WHERE CHR.STS_CODE = CST.CODE
414: AND CHR.DATE_TERMINATED IS NULL
415: AND CST.STE_CODE IN ( 'ACTIVE', 'SIGNED')

Line 2821: okc_k_headers_b kh,

2817: kh.scs_code, okl.tax_amount -- bug 3736860
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,

Line 2866: FROM okc_k_lines_v ol, oks_k_lines_b kl, okc_k_headers_b oh

2862: -- ,OL.unit_price
2863: --,OL.cle_id_renewed
2864: , ol.sts_code, oh.contract_number_modifier, kl.acct_rule_id,
2865: kl.tax_code --Bug#4121175
2866: FROM okc_k_lines_v ol, oks_k_lines_b kl, okc_k_headers_b oh
2867: WHERE ol.dnz_chr_id = p_hdr_id
2868: AND oh.ID = ol.dnz_chr_id
2869: AND kl.cle_id(+) = ol.ID -- Vigandhi 06-Jan-2004
2870: AND oh.scs_code IN ('WARRANTY', 'SERVICE', 'SUBSCRIPTION')

Line 4998: -- From okc_k_headers_b kh

4994:
4995: -- Cursor l_chr_csr Is
4996: -- select vc.object1_id1
4997: -- ,kh.authoring_org_id
4998: -- From okc_k_headers_b kh
4999: -- ,okc_k_party_roles_B pr
5000: -- ,okc_contacts vc
5001: -- Where kh.id = p_contract_id
5002: -- And pr.chr_id = p_contract_id

Line 5012: FROM okc_k_headers_b kh, okc_k_party_roles_b pr, okc_contacts vc

5008: -- and nvl(vc.end_date,sysdate) ;
5009: CURSOR l_chr_csr
5010: IS
5011: SELECT vc.object1_id1, kh.authoring_org_id
5012: FROM okc_k_headers_b kh, okc_k_party_roles_b pr, okc_contacts vc
5013: WHERE kh.ID = p_contract_id
5014: AND pr.chr_id = p_contract_id
5015: AND vc.dnz_chr_id = p_contract_id
5016: AND vc.cpl_id = pr.ID

Line 5145: -- FROM okc_k_headers_b kh,

5141: -- kh.sts_code,
5142: -- kh.id contract_id,
5143: -- Nvl(rul.rule_information1,0) percent,
5144: -- st.ste_code
5145: -- FROM okc_k_headers_b kh,
5146: -- okc_statuses_b st,
5147: -- okc_rules_b rul
5148: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5149: -- AND kh.sts_code = st.code

Line 5171: -- FROM okc_k_headers_b kh,

5167: -- kh.sts_code,
5168: -- kh.id contract_id,
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')

Line 5199: FROM okc_k_headers_b kh,

5195: CURSOR l_kh_csr1
5196: IS
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

Line 5222: FROM okc_k_headers_b kh,

5218: CURSOR l_kh_csr2
5219: IS
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

Line 5244: FROM okc_k_headers_b kh,

5240: CURSOR l_kh_csr3
5241: IS
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

Line 5266: FROM okc_k_headers_b kh,

5262: CURSOR l_kh_csr4
5263: IS
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

Line 5357: currency_code okc_k_headers_b.currency_code%TYPE,

5353: AND TRUNC (SYSDATE) BETWEEN NVL (con.start_date, SYSDATE - 1)
5354: AND NVL (con.end_date, SYSDATE);
5355:
5356: TYPE kh_rectype IS RECORD (
5357: currency_code okc_k_headers_b.currency_code%TYPE,
5358: sts_code okc_k_headers_b.sts_code%TYPE,
5359: contract_id okc_k_headers_b.ID%TYPE,
5360: PERCENT VARCHAR2 (50),
5361: ste_code okc_statuses_b.ste_code%TYPE

Line 5358: sts_code okc_k_headers_b.sts_code%TYPE,

5354: AND NVL (con.end_date, SYSDATE);
5355:
5356: TYPE kh_rectype IS RECORD (
5357: currency_code okc_k_headers_b.currency_code%TYPE,
5358: sts_code okc_k_headers_b.sts_code%TYPE,
5359: contract_id okc_k_headers_b.ID%TYPE,
5360: PERCENT VARCHAR2 (50),
5361: ste_code okc_statuses_b.ste_code%TYPE
5362: );

Line 5359: contract_id okc_k_headers_b.ID%TYPE,

5355:
5356: TYPE kh_rectype IS RECORD (
5357: currency_code okc_k_headers_b.currency_code%TYPE,
5358: sts_code okc_k_headers_b.sts_code%TYPE,
5359: contract_id okc_k_headers_b.ID%TYPE,
5360: PERCENT VARCHAR2 (50),
5361: ste_code okc_statuses_b.ste_code%TYPE
5362: );
5363: