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_BILL_REC_PUB dependencies on OKC_K_HEADERS_B

Line 353: FROM okc_k_headers_b hdr ,

349: ,line.lse_id
350: ,line.line_number
351: ,hdr.currency_code
352: ,hdr.id
353: FROM okc_k_headers_b hdr ,
354: okc_k_lines_B line
355: WHERE line.id = p_cle_id
356: AND line.dnz_chr_id = hdr.id;
357:

Line 372: ,okc_k_headers_b hdr

368: SELECT primary_uom_code
369: FROM Okc_K_items Item
370: ,mtl_system_items mtl
371: ,okc_k_lines_b line
372: ,okc_k_headers_b hdr
373: WHERE item.cle_id = p_cle_id
374: AND line.id = item.cle_id
375: AND hdr.id = line.dnz_chr_id
376: AND mtl.inventory_item_id = item.object1_id1

Line 907: ,okc_k_headers_b hdr

903: SELECT mtl.primary_uom_code,
904: line.dnz_chr_id
905: FROM Okc_K_items Item
906: ,mtl_system_items_b mtl --Okx_system_items_v mtl
907: ,okc_k_headers_b hdr
908: ,okc_k_lines_b line
909: WHERE item.cle_id = line.id --p_cle_id
910: AND line.id = p_cle_id
911: AND line.dnz_chr_id = hdr.id

Line 1269: okc_k_headers_b okh

1265: okh.currency_code,
1266: okh.contract_number,
1267: okh.contract_number_modifier
1268: FROM okc_k_lines_b okl,
1269: okc_k_headers_b okh
1270: WHERE okh.id = p_hdr_id
1271: AND okl.dnz_chr_id = okh.id
1272: AND okl.cle_id is null
1273: AND okl.date_cancelled is null --LLC BUG FIX 4742661

Line 1365: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1361: l_term_method VARCHAR2(10);
1362: l_usage_type VARCHAR2(10);
1363: l_usage_period VARCHAR2(10);
1364: ----Hari fix for bug 5667743
1365: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1366: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE;
1367: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
1368: l_term_date DATE;
1369: l_max_bill_date DATE;

Line 1366: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE;

1362: l_usage_type VARCHAR2(10);
1363: l_usage_period VARCHAR2(10);
1364: ----Hari fix for bug 5667743
1365: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1366: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE;
1367: l_billed_at_source OKC_K_HEADERS_ALL_B.BILLED_AT_SOURCE%TYPE;
1368: l_term_date DATE;
1369: l_max_bill_date DATE;
1370: l_max_ship_date DATE;

Line 1373: l_currency_code okc_k_headers_b.currency_code%TYPE;

1369: l_max_bill_date DATE;
1370: l_max_ship_date DATE;
1371: l_billed BOOLEAN ;
1372: l_tang BOOLEAN ;
1373: l_currency_code okc_k_headers_b.currency_code%TYPE;
1374: l_orig_price NUMBER;
1375: -------------------------------------------------------------------------
1376: -- Begin partial period computation logic
1377: -- Developer Mani Choudhary

Line 2655: okc_k_headers_b hdr

2651: rhdr.cc_expiry_date,
2652: rhdr.cc_bank_acct_id,
2653: hdr.bill_to_site_use_id
2654: FROM oks_k_headers_b rhdr,
2655: okc_k_headers_b hdr
2656: WHERE rhdr.chr_id = hdr.id
2657: AND hdr.id = p_hdr_id;
2658:
2659: Cursor line_grp_csr(p_hdr_id IN NUMBER) Is

Line 2875: FROM okc_k_headers_b

2871:
2872:
2873: Cursor l_curr_csr(p_chr_id number) is
2874: SELECT currency_code
2875: FROM okc_k_headers_b
2876: WHERE id = p_chr_id;
2877:
2878: Cursor qty_uom_csr(p_cle_id Number) Is
2879: SELECt okc.Number_of_items

Line 2902: okc_k_headers_b hdr

2898: SELECT p.line_number||'.'||s.line_number,
2899: hdr.contract_number
2900: FROM okc_k_lines_b p,
2901: okc_k_lines_b s,
2902: okc_k_headers_b hdr
2903: WHERE s.id=p_id
2904: AND p.id=s.cle_id
2905: AND hdr.id=p.dnz_chr_id;
2906:

Line 3209: okc_k_headers_b hdr

3205: ,line.dnz_chr_id
3206: ,line.lse_id
3207: ,hdr.currency_code
3208: FROM Okc_k_lines_B line,
3209: okc_k_headers_b hdr
3210: WHERE line.Cle_id = p_k_line_id
3211: AND line.dnz_chr_id = hdr.id;
3212:
3213:

Line 4038: okc_k_headers_b hdr

4034: /* Start Addition for bug fix 6012384 (FP for 5469820) */
4035: lines.end_date
4036: /* End Addition for bug fix 6012384 (FP for 5469820) */
4037: FROM okc_k_lines_b lines,
4038: okc_k_headers_b hdr
4039: WHERE hdr.id = p_hdr_id
4040: AND lines.dnz_chr_id = hdr.id
4041: AND lines.date_cancelled is null --LLC BUG FIX 4742661
4042: And lines.date_terminated is null

Line 4054: -- okc_k_headers_b hdr

4050: and a.allowed_yn = 'Y')
4051: OR
4052: (lines.sts_code = 'HOLD'));
4053: --And exists (Select 1 from okc_statuses_b osb,
4054: -- okc_k_headers_b hdr
4055: -- Where osb.ste_code <> 'HOLD'
4056: -- and osb.code = Hdr.sts_code ));
4057:
4058: Cursor line_Det (p_line_id IN NUMBER) is

Line 4065: FROM okc_k_headers_b hdr,

4061: lines.end_date,
4062: lines.lse_id,
4063: lines.line_number,
4064: lines.date_terminated
4065: FROM okc_k_headers_b hdr,
4066: okc_k_lines_b lines
4067: WHERE lines.id = p_line_id
4068: AND hdr.id = lines.dnz_chr_id
4069: AND hdr.sts_code <> 'QA_HOLD'

Line 4084: FROM okc_k_headers_b

4080: Cursor hdr_Det (p_hdr_id IN NUMBER) is
4081: SELECT end_date,
4082: contract_number,
4083: contract_number_modifier
4084: FROM okc_k_headers_b
4085: WHERE id = p_hdr_id;
4086:
4087: Cursor fullfilled_subscr_amount(p_id IN NUMBER) is
4088: Select nvl(sum(nvl(amount,0)),0),max(end_date)

Line 4196: okc_k_headers_b hdr

4192:
4193: Cursor cur_lineno(p_id IN NUMBER) IS
4194: SELECT lin.line_number,hdr.contract_number
4195: FROM okc_k_lines_b lin,
4196: okc_k_headers_b hdr
4197: WHERE lin.id=p_id
4198: AND hdr.id=lin.dnz_chr_id;
4199:
4200: -- End BUG#3312595 mchoudha

Line 4211: from okc_k_headers_b

4207: AND sr.status_flag = 'O';
4208:
4209: Cursor cur_contract_num IS
4210: select contract_number
4211: from okc_k_headers_b
4212: where id=p_id;
4213: --END Bug 4354983
4214:
4215: Cursor avg_bcl_amount_partial (p_cle_id in number) is

Line 5153: update okc_k_headers_b

5149: where id = l_bsl_cle_id
5150: and lse_id <>13;
5151: End If;
5152: If sql%rowcount > 0 then
5153: update okc_k_headers_b
5154: set estimated_amount = estimated_amount - ( l_termination_amount - g_credit_amount )
5155: where id = p_id;
5156: End if;
5157: open sub_line_tax(l_bsl_cle_id);

Line 5228: update okc_k_headers_b

5224: where id = l_bsl_cle_id
5225: and lse_id <>13;
5226: End If;
5227: If sql%rowcount > 0 then
5228: update okc_k_headers_b
5229: set estimated_amount = estimated_amount + ( g_credit_amount - l_termination_amount )
5230: where id = p_id;
5231: End if;
5232: open sub_line_tax(l_bsl_cle_id);

Line 6918: FROM okc_k_headers_b

6914: Cursor l_get_conversion_rule (p_chr_id IN NUMBER) is
6915: SELECT conversion_rate con_rate,
6916: conversion_rate_date con_date,
6917: conversion_type con_type
6918: FROM okc_k_headers_b
6919: WHERE id = p_chr_id;
6920:
6921:
6922: BEGIN

Line 7350: FROM okc_k_headers_b

7346: Cursor l_get_conversion_rule (p_chr_id IN NUMBER) is
7347: SELECT conversion_rate con_rate,
7348: conversion_rate_date con_date,
7349: conversion_type con_type
7350: FROM okc_k_headers_b
7351: WHERE id = p_chr_id;
7352:
7353:
7354:

Line 7753: OKC_K_HEADERS_B Hdr,

7749: rules.rule_information6 Primary_period,
7750: rules.rule_information8 Secondary_period
7751:
7752: From OKC_K_LINES_B line,
7753: OKC_K_HEADERS_B Hdr,
7754: OKC_RULES_B rules,
7755: OKC_RULE_GROUPS_B rlgrp
7756:
7757: Where line.lse_id in (1,12)

Line 8136: okc_k_headers_b hdr,

8132: line1.end_date,line1.sts_code,
8133: hdr.id
8134: FROM okc_k_lines_b line2,
8135: okc_k_lines_b line1,
8136: okc_k_headers_b hdr,
8137: oks_k_lines_b rline
8138: WHERE line1.id = p_cle_id
8139: AND line2.id = line1.cle_id
8140: AND rline.cle_id = line2.id

Line 8602: okc_k_headers_b hdr

8598: SELECT p.line_number||'.'||s.line_number,
8599: hdr.contract_number
8600: FROM okc_k_lines_b p,
8601: okc_k_lines_b s,
8602: okc_k_headers_b hdr
8603: WHERE s.id=p_id
8604: AND p.id=s.cle_id
8605: AND hdr.id=p.dnz_chr_id;
8606:

Line 9202: FROM okc_k_headers_b

9198: WHERE OKCL.id = p_id ;
9199:
9200: CURSOR L_HDR_CURR_CODE (p_id in number ) is
9201: SELECT currency_code
9202: FROM okc_k_headers_b
9203: WHERE id = p_id;
9204:
9205: CURSOR l_line_curr_code (p_id in number ) is
9206: SELECT hdr.currency_code ,hdr.id

Line 9208: okc_k_headers_b hdr

9204:
9205: CURSOR l_line_curr_code (p_id in number ) is
9206: SELECT hdr.currency_code ,hdr.id
9207: FROM okc_k_lines_b lines,
9208: okc_k_headers_b hdr
9209: WHERE lines.id = p_id
9210: AND hdr.id = lines.dnz_chr_id;
9211:
9212: CURSOR l_check_for_full_credit(p_top_line_id in NUMBER ) is

Line 9479: UPDATE OKC_K_HEADERS_B

9475: CREDIT_AMOUNT = nvl(CREDIT_AMOUNT,0) + nvl(l_credit,0) ,
9476: SUPPRESSED_CREDIT = nvl(SUPPRESSED_CREDIT,0) + nvl(l_suppressed_credit,0)
9477: WHERE cle_id = l_top_line_id;
9478:
9479: UPDATE OKC_K_HEADERS_B
9480: SET estimated_amount=(SELECT SUM(price_negotiated)
9481: FROM OKC_K_LINES_B
9482: WHERE dnz_chr_id = l_hdr_id
9483: AND lse_id in ( 1,12,14,19,46))

Line 9762: UPDATE OKC_K_HEADERS_B

9758: --mchoudha 11510+ Usage Tax and Price Display
9759: --added lse_id 12
9760: IF p_true_value_tbl(1).p_hdr_id = 0 then
9761: IF l_lse_id_rec.lse_id in ( 1,12,19,46 ) then
9762: UPDATE OKC_K_HEADERS_B
9763: SET estimated_amount=(SELECT SUM(price_negotiated)
9764: FROM OKC_K_LINES_B
9765: WHERE dnz_chr_id = l_hdr_id
9766: AND lse_id in ( 1,12,14,19,46))

Line 9779: UPDATE OKC_K_HEADERS_B

9775: ELSIF l_termn_level = 'HD' then
9776: -------------------------------------------------------------------------
9777: -- True value processing for Header Termination --
9778: -------------------------------------------------------------------------
9779: UPDATE OKC_K_HEADERS_B
9780: SET estimated_amount=(SELECT SUM(price_negotiated)
9781: FROM OKC_K_LINES_B
9782: WHERE dnz_chr_id = p_true_value_tbl(1).p_hdr_id
9783: AND lse_id in ( 1,12,14,19,46))

Line 9809: OKC_K_HEADERS_B hdr

9805: CURSOR price_break_csr (P_BSL_ID IN NUMBER) is
9806: SELECT pb.id, pb.amount,pb.unit_price , pb.quantity ,
9807: hdr.currency_code
9808: FROM OKS_PRICE_BREAKS pb,
9809: OKC_K_HEADERS_B hdr
9810: WHERE pb.bsl_id = P_BSL_ID
9811: AND pb.chr_id = hdr.id
9812: ORDER BY pb.quantity_from;
9813:

Line 9932: FROM okc_k_headers_b

9928: WHERE cle_id = p_cle_id;
9929:
9930: CURSOR L_HDR_CURR_CODE (p_id in number ) is
9931: SELECT currency_code
9932: FROM okc_k_headers_b
9933: WHERE id = p_id;
9934:
9935: CURSOR l_line_BS_csr(p_line_id NUMBER,p_date in date) IS
9936: SELECT id,trunc(date_start) date_start,