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 356: FROM okc_k_headers_b hdr ,

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

Line 375: ,okc_k_headers_b hdr

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

Line 926: ,okc_k_headers_b hdr

922: SELECT mtl.primary_uom_code,
923: line.dnz_chr_id
924: FROM Okc_K_items Item
925: ,mtl_system_items_b mtl --Okx_system_items_v mtl
926: ,okc_k_headers_b hdr
927: ,okc_k_lines_b line
928: WHERE item.cle_id = line.id --p_cle_id
929: AND line.id = p_cle_id
930: AND line.dnz_chr_id = hdr.id

Line 1290: okc_k_headers_b okh

1286: okh.currency_code,
1287: okh.contract_number,
1288: okh.contract_number_modifier
1289: FROM okc_k_lines_b okl,
1290: okc_k_headers_b okh
1291: WHERE okh.id = p_hdr_id
1292: AND okl.dnz_chr_id = okh.id
1293: AND okl.cle_id is null
1294: AND okl.date_cancelled is null --LLC BUG FIX 4742661

Line 1312: FROM okc_k_headers_b okh,

1308: okl.cle_id ,
1309: okl.price_negotiated,
1310: okh.contract_number,
1311: okh.contract_number_modifier
1312: FROM okc_k_headers_b okh,
1313: okc_k_lines_b okl
1314: WHERE okl.id = p_id
1315: AND okh.id = okl.dnz_chr_id;
1316:

Line 1385: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

1381: l_term_method VARCHAR2(10);
1382: l_usage_type VARCHAR2(10);
1383: l_usage_period VARCHAR2(10);
1384: ----Hari fix for bug 5667743
1385: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1386: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE;
1387: l_term_date DATE;
1388: l_max_bill_date DATE;
1389: l_max_ship_date DATE;

Line 1386: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE;

1382: l_usage_type VARCHAR2(10);
1383: l_usage_period VARCHAR2(10);
1384: ----Hari fix for bug 5667743
1385: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
1386: l_contract_modifier OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%TYPE;
1387: l_term_date DATE;
1388: l_max_bill_date DATE;
1389: l_max_ship_date DATE;
1390: l_billed BOOLEAN ;

Line 1392: l_currency_code okc_k_headers_b.currency_code%TYPE;

1388: l_max_bill_date DATE;
1389: l_max_ship_date DATE;
1390: l_billed BOOLEAN ;
1391: l_tang BOOLEAN ;
1392: l_currency_code okc_k_headers_b.currency_code%TYPE;
1393: l_orig_price NUMBER;
1394: -------------------------------------------------------------------------
1395: -- Begin partial period computation logic
1396: -- Developer Mani Choudhary

Line 2669: okc_k_headers_b hdr

2665: rhdr.cc_expiry_date,
2666: rhdr.cc_bank_acct_id,
2667: hdr.bill_to_site_use_id
2668: FROM oks_k_headers_b rhdr,
2669: okc_k_headers_b hdr
2670: WHERE rhdr.chr_id = hdr.id
2671: AND hdr.id = p_hdr_id;
2672:
2673: Cursor line_grp_csr(p_hdr_id IN NUMBER) Is

Line 2889: FROM okc_k_headers_b

2885:
2886:
2887: Cursor l_curr_csr(p_chr_id number) is
2888: SELECT currency_code
2889: FROM okc_k_headers_b
2890: WHERE id = p_chr_id;
2891:
2892: Cursor qty_uom_csr(p_cle_id Number) Is
2893: SELECt okc.Number_of_items

Line 2916: okc_k_headers_b hdr

2912: SELECT p.line_number||'.'||s.line_number,
2913: hdr.contract_number
2914: FROM okc_k_lines_b p,
2915: okc_k_lines_b s,
2916: okc_k_headers_b hdr
2917: WHERE s.id=p_id
2918: AND p.id=s.cle_id
2919: AND hdr.id=p.dnz_chr_id;
2920:

Line 3224: okc_k_headers_b hdr

3220: ,line.dnz_chr_id
3221: ,line.lse_id
3222: ,hdr.currency_code
3223: FROM Okc_k_lines_B line,
3224: okc_k_headers_b hdr
3225: WHERE line.Cle_id = p_k_line_id
3226: AND line.dnz_chr_id = hdr.id;*/
3227:
3228: /* Added Cursor for Bug#14647106 */

Line 3232: okc_k_headers_b hdr

3228: /* Added Cursor for Bug#14647106 */
3229: CURSOR l_date_csr Is
3230: SELECT max(line.End_date) end_date
3231: FROM okc_k_lines_B line,
3232: okc_k_headers_b hdr
3233: WHERE line.Cle_id = p_k_line_id
3234: AND line.dnz_chr_id = hdr.id;
3235:
3236: CURSOR l_start_date_csr(p_id in NUMBER ) is

Line 4064: okc_k_headers_b hdr

4060: /* Start Addition for bug fix 6012384 (FP for 5469820) */
4061: lines.end_date
4062: /* End Addition for bug fix 6012384 (FP for 5469820) */
4063: FROM okc_k_lines_b lines,
4064: okc_k_headers_b hdr
4065: WHERE hdr.id = p_hdr_id
4066: AND lines.dnz_chr_id = hdr.id
4067: AND lines.date_cancelled is null --LLC BUG FIX 4742661
4068: And lines.date_terminated is null

Line 4080: -- okc_k_headers_b hdr

4076: and a.allowed_yn = 'Y')
4077: OR
4078: (lines.sts_code = 'HOLD'));
4079: --And exists (Select 1 from okc_statuses_b osb,
4080: -- okc_k_headers_b hdr
4081: -- Where osb.ste_code <> 'HOLD'
4082: -- and osb.code = Hdr.sts_code ));
4083:
4084: Cursor line_Det (p_line_id IN NUMBER) is

Line 4091: FROM okc_k_headers_b hdr,

4087: lines.end_date,
4088: lines.lse_id,
4089: lines.line_number,
4090: lines.date_terminated
4091: FROM okc_k_headers_b hdr,
4092: okc_k_lines_b lines
4093: WHERE lines.id = p_line_id
4094: AND hdr.id = lines.dnz_chr_id
4095: AND hdr.sts_code <> 'QA_HOLD'

Line 4110: FROM okc_k_headers_b

4106: Cursor hdr_Det (p_hdr_id IN NUMBER) is
4107: SELECT end_date,
4108: contract_number,
4109: contract_number_modifier
4110: FROM okc_k_headers_b
4111: WHERE id = p_hdr_id;
4112:
4113: Cursor fullfilled_subscr_amount(p_id IN NUMBER) is
4114: Select nvl(sum(nvl(amount,0)),0),max(end_date)

Line 4222: okc_k_headers_b hdr

4218:
4219: Cursor cur_lineno(p_id IN NUMBER) IS
4220: SELECT lin.line_number,hdr.contract_number
4221: FROM okc_k_lines_b lin,
4222: okc_k_headers_b hdr
4223: WHERE lin.id=p_id
4224: AND hdr.id=lin.dnz_chr_id;
4225:
4226: -- End BUG#3312595 mchoudha

Line 4237: from okc_k_headers_b

4233: AND sr.status_flag = 'O';
4234:
4235: Cursor cur_contract_num IS
4236: select contract_number
4237: from okc_k_headers_b
4238: where id=p_id;
4239: --END Bug 4354983
4240:
4241: Cursor avg_bcl_amount_partial (p_cle_id in number) is

Line 5179: update okc_k_headers_b

5175: where id = l_bsl_cle_id
5176: and lse_id <>13;
5177: End If;
5178: If sql%rowcount > 0 then
5179: update okc_k_headers_b
5180: set estimated_amount = estimated_amount - ( l_termination_amount - g_credit_amount )
5181: where id = p_id;
5182: End if;
5183: open sub_line_tax(l_bsl_cle_id);

Line 5254: update okc_k_headers_b

5250: where id = l_bsl_cle_id
5251: and lse_id <>13;
5252: End If;
5253: If sql%rowcount > 0 then
5254: update okc_k_headers_b
5255: set estimated_amount = estimated_amount + ( g_credit_amount - l_termination_amount )
5256: where id = p_id;
5257: End if;
5258: open sub_line_tax(l_bsl_cle_id);

Line 6950: FROM okc_k_headers_b

6946: Cursor l_get_conversion_rule (p_chr_id IN NUMBER) is
6947: SELECT conversion_rate con_rate,
6948: conversion_rate_date con_date,
6949: conversion_type con_type
6950: FROM okc_k_headers_b
6951: WHERE id = p_chr_id;
6952:
6953:
6954: BEGIN

Line 7382: FROM okc_k_headers_b

7378: Cursor l_get_conversion_rule (p_chr_id IN NUMBER) is
7379: SELECT conversion_rate con_rate,
7380: conversion_rate_date con_date,
7381: conversion_type con_type
7382: FROM okc_k_headers_b
7383: WHERE id = p_chr_id;
7384:
7385:
7386:

Line 7785: OKC_K_HEADERS_B Hdr,

7781: rules.rule_information6 Primary_period,
7782: rules.rule_information8 Secondary_period
7783:
7784: From OKC_K_LINES_B line,
7785: OKC_K_HEADERS_B Hdr,
7786: OKC_RULES_B rules,
7787: OKC_RULE_GROUPS_B rlgrp
7788:
7789: Where line.lse_id in (1,12)

Line 8168: okc_k_headers_b hdr,

8164: line1.end_date,line1.sts_code,
8165: hdr.id
8166: FROM okc_k_lines_b line2,
8167: okc_k_lines_b line1,
8168: okc_k_headers_b hdr,
8169: oks_k_lines_b rline
8170: WHERE line1.id = p_cle_id
8171: AND line2.id = line1.cle_id
8172: AND rline.cle_id = line2.id

Line 8642: okc_k_headers_b hdr

8638: SELECT p.line_number||'.'||s.line_number,
8639: hdr.contract_number
8640: FROM okc_k_lines_b p,
8641: okc_k_lines_b s,
8642: okc_k_headers_b hdr
8643: WHERE s.id=p_id
8644: AND p.id=s.cle_id
8645: AND hdr.id=p.dnz_chr_id;
8646:

Line 9244: FROM okc_k_headers_b

9240: WHERE OKCL.id = p_id ;
9241:
9242: CURSOR L_HDR_CURR_CODE (p_id in number ) is
9243: SELECT currency_code
9244: FROM okc_k_headers_b
9245: WHERE id = p_id;
9246:
9247: CURSOR l_line_curr_code (p_id in number ) is
9248: SELECT hdr.currency_code ,hdr.id

Line 9250: okc_k_headers_b hdr

9246:
9247: CURSOR l_line_curr_code (p_id in number ) is
9248: SELECT hdr.currency_code ,hdr.id
9249: FROM okc_k_lines_b lines,
9250: okc_k_headers_b hdr
9251: WHERE lines.id = p_id
9252: AND hdr.id = lines.dnz_chr_id;
9253:
9254: CURSOR l_check_for_full_credit(p_top_line_id in NUMBER ) is

Line 9541: UPDATE OKC_K_HEADERS_B

9537: CREDIT_AMOUNT = nvl(CREDIT_AMOUNT,0) + nvl(l_credit,0) ,
9538: SUPPRESSED_CREDIT = nvl(SUPPRESSED_CREDIT,0) + nvl(l_suppressed_credit,0)
9539: WHERE cle_id = l_top_line_id;
9540:
9541: UPDATE OKC_K_HEADERS_B
9542: SET estimated_amount=(SELECT SUM(price_negotiated)
9543: FROM OKC_K_LINES_B
9544: WHERE dnz_chr_id = l_hdr_id
9545: AND lse_id in ( 1,12,14,19,46))

Line 9849: UPDATE OKC_K_HEADERS_B

9845: --mchoudha 11510+ Usage Tax and Price Display
9846: --added lse_id 12
9847: IF p_true_value_tbl(1).p_hdr_id = 0 then
9848: IF l_lse_id_rec.lse_id in ( 1,12,19,46 ) then
9849: UPDATE OKC_K_HEADERS_B
9850: SET estimated_amount=(SELECT SUM(price_negotiated)
9851: FROM OKC_K_LINES_B
9852: WHERE dnz_chr_id = l_hdr_id
9853: AND lse_id in ( 1,12,14,19,46))

Line 9866: UPDATE OKC_K_HEADERS_B

9862: ELSIF l_termn_level = 'HD' then
9863: -------------------------------------------------------------------------
9864: -- True value processing for Header Termination --
9865: -------------------------------------------------------------------------
9866: UPDATE OKC_K_HEADERS_B
9867: SET estimated_amount=(SELECT SUM(price_negotiated)
9868: FROM OKC_K_LINES_B
9869: WHERE dnz_chr_id = p_true_value_tbl(1).p_hdr_id
9870: AND lse_id in ( 1,12,14,19,46))

Line 9899: OKC_K_HEADERS_B hdr

9895: CURSOR price_break_csr (P_BSL_ID IN NUMBER) is
9896: SELECT pb.id, pb.amount,pb.unit_price , pb.quantity ,
9897: hdr.currency_code
9898: FROM OKS_PRICE_BREAKS pb,
9899: OKC_K_HEADERS_B hdr
9900: WHERE pb.bsl_id = P_BSL_ID
9901: AND pb.chr_id = hdr.id
9902: ORDER BY pb.quantity_from;
9903:

Line 10022: FROM okc_k_headers_b

10018: WHERE cle_id = p_cle_id;
10019:
10020: CURSOR L_HDR_CURR_CODE (p_id in number ) is
10021: SELECT currency_code
10022: FROM okc_k_headers_b
10023: WHERE id = p_id;
10024:
10025: CURSOR l_line_BS_csr(p_line_id NUMBER,p_date in date) IS
10026: SELECT id,trunc(date_start) date_start,