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 2867: okc_k_headers_b kh,

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

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

2908: -- ,OL.unit_price
2909: --,OL.cle_id_renewed
2910: , ol.sts_code, oh.contract_number_modifier, kl.acct_rule_id,
2911: kl.tax_code --Bug#4121175
2912: FROM okc_k_lines_v ol, oks_k_lines_b kl, okc_k_headers_b oh
2913: WHERE ol.dnz_chr_id = p_hdr_id
2914: AND oh.ID = ol.dnz_chr_id
2915: AND kl.cle_id(+) = ol.ID -- Vigandhi 06-Jan-2004
2916: AND oh.scs_code IN ('WARRANTY', 'SERVICE', 'SUBSCRIPTION')

Line 5044: -- From okc_k_headers_b kh

5040:
5041: -- Cursor l_chr_csr Is
5042: -- select vc.object1_id1
5043: -- ,kh.authoring_org_id
5044: -- From okc_k_headers_b kh
5045: -- ,okc_k_party_roles_B pr
5046: -- ,okc_contacts vc
5047: -- Where kh.id = p_contract_id
5048: -- And pr.chr_id = p_contract_id

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

5054: -- and nvl(vc.end_date,sysdate) ;
5055: CURSOR l_chr_csr
5056: IS
5057: SELECT vc.object1_id1, kh.authoring_org_id
5058: FROM okc_k_headers_b kh, okc_k_party_roles_b pr, okc_contacts vc
5059: WHERE kh.ID = p_contract_id
5060: AND pr.chr_id = p_contract_id
5061: AND vc.dnz_chr_id = p_contract_id
5062: AND vc.cpl_id = pr.ID

Line 5191: -- FROM okc_k_headers_b kh,

5187: -- kh.sts_code,
5188: -- kh.id contract_id,
5189: -- Nvl(rul.rule_information1,0) percent,
5190: -- st.ste_code
5191: -- FROM okc_k_headers_b kh,
5192: -- okc_statuses_b st,
5193: -- okc_rules_b rul
5194: -- WHERE kh.authoring_org_id = NVL(p_orgid,kh.authoring_org_id)
5195: -- AND kh.sts_code = st.code

Line 5217: -- FROM okc_k_headers_b kh,

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

Line 5245: FROM okc_k_headers_b kh,

5241: CURSOR l_kh_csr1
5242: IS
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

Line 5268: FROM okc_k_headers_b kh,

5264: CURSOR l_kh_csr2
5265: IS
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

Line 5290: FROM okc_k_headers_b kh,

5286: CURSOR l_kh_csr3
5287: IS
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

Line 5312: FROM okc_k_headers_b kh,

5308: CURSOR l_kh_csr4
5309: IS
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

Line 5403: currency_code okc_k_headers_b.currency_code%TYPE,

5399: AND TRUNC (SYSDATE) BETWEEN NVL (con.start_date, SYSDATE - 1)
5400: AND NVL (con.end_date, SYSDATE);
5401:
5402: TYPE kh_rectype IS RECORD (
5403: currency_code okc_k_headers_b.currency_code%TYPE,
5404: sts_code okc_k_headers_b.sts_code%TYPE,
5405: contract_id okc_k_headers_b.ID%TYPE,
5406: PERCENT VARCHAR2 (50),
5407: ste_code okc_statuses_b.ste_code%TYPE

Line 5404: sts_code okc_k_headers_b.sts_code%TYPE,

5400: AND NVL (con.end_date, SYSDATE);
5401:
5402: TYPE kh_rectype IS RECORD (
5403: currency_code okc_k_headers_b.currency_code%TYPE,
5404: sts_code okc_k_headers_b.sts_code%TYPE,
5405: contract_id okc_k_headers_b.ID%TYPE,
5406: PERCENT VARCHAR2 (50),
5407: ste_code okc_statuses_b.ste_code%TYPE
5408: );

Line 5405: contract_id okc_k_headers_b.ID%TYPE,

5401:
5402: TYPE kh_rectype IS RECORD (
5403: currency_code okc_k_headers_b.currency_code%TYPE,
5404: sts_code okc_k_headers_b.sts_code%TYPE,
5405: contract_id okc_k_headers_b.ID%TYPE,
5406: PERCENT VARCHAR2 (50),
5407: ste_code okc_statuses_b.ste_code%TYPE
5408: );
5409: