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_RENEW_CONTRACT_PVT dependencies on OKS_K_LINES_B

Line 921: FROM okc_k_lines_b c, oks_k_lines_b s

917: l_reprice_rec OKS_REPRICE_PVT.reprice_rec_type;
918:
919: CURSOR c_top_lines(cp_chr_id IN NUMBER) IS
920: SELECT c.cle_id, sum(nvl(c.price_negotiated,0)), sum(nvl(s.tax_amount,0))
921: FROM okc_k_lines_b c, oks_k_lines_b s
922: WHERE c.dnz_chr_id = cp_chr_id
923: --get only sublines for 1,12,19 (14:no renewal, 46:no sublines)
924: AND c.lse_id IN (7,8,9,10,11,35, 13, 25)
925: AND s.cle_id = c.id

Line 1005: UPDATE oks_k_lines_b

1001: SET price_negotiated = l_price_tbl(i)
1002: WHERE id = l_id_tbl(i);
1003:
1004: FORALL i IN l_id_tbl.first..l_id_tbl.last
1005: UPDATE oks_k_lines_b
1006: SET tax_amount = l_tax_tbl(i)
1007: WHERE cle_id = l_id_tbl(i);
1008: END LOOP;
1009: CLOSE c_top_lines;

Line 1028: (SELECT sum(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl

1024: WHERE h.id = p_chr_id;
1025:
1026: UPDATE oks_k_headers_b h
1027: SET h.tax_amount =
1028: (SELECT sum(stl.tax_amount) FROM okc_k_lines_b ctl, oks_k_lines_b stl
1029: WHERE ctl.dnz_chr_id = p_chr_id AND ctl.cle_id IS NULL
1030: AND ctl.lse_id IN (1,12,19,46) AND stl.cle_id = ctl.id)
1031: WHERE h.chr_id = p_chr_id;
1032:

Line 2076: FROM okc_k_lines_b oldc, oks_k_lines_b olds, okc_k_lines_b newc

2072: l_old_break_uom_tbl chr_tbl_type;
2073:
2074: CURSOR c_get_usage_price_locks(cp_chr_id IN NUMBER) IS
2075: SELECT olds.locked_price_list_line_id, newc.id, nvl(olds.break_uom, 'X')
2076: FROM okc_k_lines_b oldc, oks_k_lines_b olds, okc_k_lines_b newc
2077: WHERE newc.dnz_chr_id = cp_chr_id AND newc.lse_id IN (12, 13)
2078: AND oldc.id = newc.orig_system_id1 AND olds.cle_id = oldc.id
2079: AND olds.locked_price_list_id IS NOT NULL
2080: AND nvl(oldc.price_list_id, -99) = nvl(newc.price_list_id, -98);

Line 2148: UPDATE oks_k_lines_b

2144:
2145: END LOOP; --of FOR i IN l_new_cid_tbl.first..l_new_cid_tbl.last LOOP
2146:
2147: FORALL i IN l_new_cid_tbl.first..l_new_cid_tbl.last
2148: UPDATE oks_k_lines_b
2149: SET locked_price_list_id = l_new_lpl_tbl(i),
2150: locked_price_list_line_id = l_new_lpll_tbl(i),
2151: break_uom = l_old_break_uom_tbl(i)
2152: WHERE cle_id = l_new_cid_tbl(i);

Line 2398: FROM okc_k_lines_b renc, oks_k_lines_b rens,

2394: SELECT renc.id, renc.inv_rule_id, renc.orig_system_id1, rens.billing_schedule_type,
2395: nvl(renc.price_negotiated,0) new_line_amt,
2396: (nvl(oldc.price_negotiated, 0) + nvl(olds.ubt_amount, 0) +
2397: nvl(olds.credit_amount, 0) + nvl(olds.suppressed_credit, 0) ) old_line_amt
2398: FROM okc_k_lines_b renc, oks_k_lines_b rens,
2399: okc_k_lines_b oldc, oks_k_lines_b olds
2400: WHERE renc.dnz_chr_id = cp_chr_id
2401: AND renc.cle_id IS NULL AND renc.lse_id IN (1,12,19,46) AND rens.cle_id = renc.id
2402: AND oldc.id = renc.orig_system_id1

Line 2399: okc_k_lines_b oldc, oks_k_lines_b olds

2395: nvl(renc.price_negotiated,0) new_line_amt,
2396: (nvl(oldc.price_negotiated, 0) + nvl(olds.ubt_amount, 0) +
2397: nvl(olds.credit_amount, 0) + nvl(olds.suppressed_credit, 0) ) old_line_amt
2398: FROM okc_k_lines_b renc, oks_k_lines_b rens,
2399: okc_k_lines_b oldc, oks_k_lines_b olds
2400: WHERE renc.dnz_chr_id = cp_chr_id
2401: AND renc.cle_id IS NULL AND renc.lse_id IN (1,12,19,46) AND rens.cle_id = renc.id
2402: AND oldc.id = renc.orig_system_id1
2403: AND olds.cle_id = renc.orig_system_id1;

Line 2612: FROM okc_k_lines_b a, oks_k_lines_b b

2608:
2609: CURSOR c_bp_toplines (cp_chr_id IN NUMBER) IS
2610: SELECT a.id, a.start_date, a.end_date, nvl(b.billing_schedule_type, 'XX'),
2611: a.lse_id, nvl(b.usage_type, 'XX')
2612: FROM okc_k_lines_b a, oks_k_lines_b b
2613: WHERE a.dnz_chr_id = cp_chr_id AND a.id = b.cle_id
2614: AND a.cle_id IS NULL;
2615:
2616: CURSOR c_chk_accounting_rule(l_id NUMBER) IS

Line 2843: AND EXISTS (SELECT 1 FROM oks_k_lines_b b

2839:
2840: UPDATE okc_k_lines_b a
2841: SET a.inv_rule_id = -3
2842: WHERE a.dnz_chr_id = p_chr_id AND a.cle_id IS NULL AND a.lse_id = 12
2843: AND EXISTS (SELECT 1 FROM oks_k_lines_b b
2844: WHERE b.cle_id = a.id AND b.usage_type IN ('VRT', 'QTY'));
2845: END IF;
2846:
2847: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN

Line 2850: --update oks_k_lines_b toplines with acct_rule_id

2846:
2847: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2848: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'upd_acctg_rul : updating accounting rule');
2849: END IF;
2850: --update oks_k_lines_b toplines with acct_rule_id
2851: UPDATE oks_k_lines_b
2852: SET acct_rule_id = l_account_rule_id
2853: WHERE cle_id IN (SELECT id FROM okc_k_lines_b
2854: WHERE dnz_chr_id = p_chr_id AND cle_id IS NULL);

Line 2851: UPDATE oks_k_lines_b

2847: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
2848: FND_LOG.string(FND_LOG.level_statement, l_mod_name,'upd_acctg_rul : updating accounting rule');
2849: END IF;
2850: --update oks_k_lines_b toplines with acct_rule_id
2851: UPDATE oks_k_lines_b
2852: SET acct_rule_id = l_account_rule_id
2853: WHERE cle_id IN (SELECT id FROM okc_k_lines_b
2854: WHERE dnz_chr_id = p_chr_id AND cle_id IS NULL);
2855:

Line 3040: UPDATE oks_k_lines_b

3036: WHERE dnz_chr_id = p_chr_id;
3037:
3038: --doing this becuase this is what OKS_BILL_SCH.del_rul_elements does
3039: --and we are replacing that call
3040: UPDATE oks_k_lines_b
3041: SET billing_schedule_type = NULL
3042: WHERE cle_id IN
3043: (SELECT id FROM OKC_K_LINES_B WHERE dnz_chr_id = p_chr_id
3044: AND lse_id IN (7,8,9,10,11,35,13,18,25));

Line 3763: UPDATE oks_k_lines_b b

3759: SET payment_instruction_type = NULL,
3760: inv_rule_id=Nvl(inv_id,inv_rule_id) --added for bug 9020536
3761: WHERE dnz_chr_id = p_chr_id AND cle_id IS NULL AND lse_id IN (1,12,19,46);
3762:
3763: UPDATE oks_k_lines_b b
3764: SET b.cust_po_number = NULL,
3765: b.cust_po_number_req_yn = NULL,
3766: b.acct_rule_id=Nvl(acct_id,acct_rule_id) --added for bug 9020536
3767: WHERE b.dnz_chr_id = p_chr_id

Line 4542: okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl

4538: --kl.lse_id, bk.inventory_item_id id1, bk.organization_id id2 , bk.organization_id inv_org_id,
4539: sl.id, bt.description name, bk.concatenated_segments description, null,
4540: null, null, to_char(kl.start_date,'DD-MON-YYYY'), to_char(kl.end_date,'DD-MON-YYYY')
4541: FROM mtl_system_items_b_kfv bk, mtl_system_items_tl bt,
4542: okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl
4543: WHERE bk.inventory_item_id = bt.inventory_item_id
4544: AND bk.organization_id = bt.organization_id
4545: AND bt.language = USERENV('LANG')
4546: AND bk.inventory_item_id = it.object1_id1

Line 4609: ) iv, okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl, okc_k_headers_all_b kh

4605: T.DESCRIPTION NAME, B.CONCATENATED_SEGMENTS DESCRIPTION, B.ORGANIZATION_ID INV_ORG_ID
4606: FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T
4607: WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
4608: AND T.LANGUAGE = USERENV('LANG')
4609: ) iv, okc_k_items it, oks_k_lines_b sl, okc_k_lines_b kl, okc_k_headers_all_b kh
4610: WHERE iv.type = it.jtot_object1_code -- bug 5218936
4611: AND iv.id1 = it.object1_id1
4612: AND iv.id2 = it.object1_id2
4613: AND decode(iv.inv_org_id, null, kh.inv_organization_id, iv.inv_org_id) = kh.inv_organization_id

Line 4631: oks_k_lines_b kl,

4627: csi_counter_associations cca ,
4628: csi_item_instances cp ,
4629: mtl_system_items_kfv it,
4630: okc_k_items items,
4631: oks_k_lines_b kl,
4632: okc_k_headers_all_b khr
4633: WHERE ccb.counter_id = cct.counter_id
4634: AND cct.language = USERENV('LANG')
4635: AND ccb.group_id = cg.counter_group_id

Line 4762: FROM oks_k_lines_tl a, oks_k_lines_b b

4758: UPDATE oks_k_lines_tl c
4759: SET c.invoice_text =
4760: (SELECT SUBSTR(a.invoice_text,1, decode(INSTR(a.invoice_text, ':'),0,
4761: LENGTH(a.invoice_text), INSTR(a.invoice_text, ':'))) ||l_inv_txt_tbl(j)
4762: FROM oks_k_lines_tl a, oks_k_lines_b b
4763: WHERE a.id = b.id AND a.language = USERENV('LANG')
4764: AND b.cle_id = l_cle_id_tbl(j))
4765: WHERE id = l_sl_id_tbl(j) AND language = USERENV('LANG');
4766: l_line_tbl.delete;