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.OKL_INTERNAL_BILLING_PVT dependencies on OKC_RULES_B

Line 267: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;

263:
264: --START: cklee 3/20/07
265: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
266:
267: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
268: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
269: l_object1_id1 okc_rules_b.object1_id1%TYPE;
270: l_object1_id2 okc_rules_b.object1_id2%TYPE;
271:

Line 268: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;

264: --START: cklee 3/20/07
265: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
266:
267: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
268: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
269: l_object1_id1 okc_rules_b.object1_id1%TYPE;
270: l_object1_id2 okc_rules_b.object1_id2%TYPE;
271:
272: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2, p_rgd_code VARCHAR2) IS

Line 269: l_object1_id1 okc_rules_b.object1_id1%TYPE;

265: l_legal_entity_id okl_trx_ar_invoices_b.legal_entity_id%TYPE; -- for LE Uptake project 08-11-2006
266:
267: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
268: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
269: l_object1_id1 okc_rules_b.object1_id1%TYPE;
270: l_object1_id2 okc_rules_b.object1_id2%TYPE;
271:
272: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2, p_rgd_code VARCHAR2) IS
273: SELECT jtot_object1_code,

Line 270: l_object1_id2 okc_rules_b.object1_id2%TYPE;

266:
267: l_jtot_object1_code okc_rules_b.jtot_object1_code%TYPE;
268: l_jtot_object2_code okc_rules_b.jtot_object2_code%TYPE;
269: l_object1_id1 okc_rules_b.object1_id1%TYPE;
270: l_object1_id2 okc_rules_b.object1_id2%TYPE;
271:
272: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2, p_rgd_code VARCHAR2) IS
273: SELECT jtot_object1_code,
274: object1_id1,

Line 276: FROM okc_rules_b

272: CURSOR rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2, p_rgd_code VARCHAR2) IS
273: SELECT jtot_object1_code,
274: object1_id1,
275: object1_id2
276: FROM okc_rules_b
277: WHERE rgp_id =
278: (SELECT id
279: FROM okc_rule_groups_b
280: WHERE dnz_chr_id = p_khr_id

Line 290: FROM okc_rules_b

286: CURSOR vendor_rule_code_csr(p_khr_id NUMBER, p_rule_category VARCHAR2, p_rgd_code VARCHAR2, p_cpl_id NUMBER) IS
287: SELECT jtot_object1_code,
288: object1_id1,
289: object1_id2
290: FROM okc_rules_b
291: WHERE rgp_id =
292: (SELECT rgp.id
293: FROM okc_rule_groups_b rgp,
294: okc_rg_party_roles rpr

Line 428: okc_rules_b b

424: -- -------------------------------------------
425: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
426: SELECT rule_information1 private_label
427: FROM okc_rule_groups_b a,
428: okc_rules_b b
429: WHERE a.dnz_chr_id = cp_khr_id
430: AND a.rgd_code = 'LALABL'
431: AND a.id = b.rgp_id
432: AND b.rule_information_category = 'LALOGO';

Line 434: l_private_label okc_rules_b.rule_information1%TYPE;

430: AND a.rgd_code = 'LALABL'
431: AND a.id = b.rgp_id
432: AND b.rule_information_category = 'LALOGO';
433:
434: l_private_label okc_rules_b.rule_information1%TYPE;
435:
436: --END: cklee 3/20/07
437:
438: begin