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_STREAM_BILLING_PVT dependencies on OKC_RULES_B

Line 107: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

103: l_ext_sob_id Okl_Ext_Sell_Invs_V.set_of_books_id%TYPE;
104: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
105: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
106: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;
107: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
108: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;

Line 108: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

104: l_ext_trx_type_id Okl_Ext_Sell_Invs_V.cust_trx_type_id%TYPE;
105: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
106: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;
107: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
108: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
112: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;

Line 109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

105: l_ext_addr_id Okl_Ext_Sell_Invs_V.customer_address_id%TYPE;
106: l_ext_cust_bank_id Okl_Ext_Sell_Invs_V.customer_bank_account_id%TYPE;
107: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
108: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
112: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
113: l_product_id okl_k_headers_full_v.pdt_id%TYPE;

Line 111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;

107: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
108: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
112: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
113: l_product_id okl_k_headers_full_v.pdt_id%TYPE;
114:
115: -- Multi Currency Compliance

Line 112: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;

108: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
112: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
113: l_product_id okl_k_headers_full_v.pdt_id%TYPE;
114:
115: -- Multi Currency Compliance
116: l_currency_code OKL_EXT_SELL_INVS_B.currency_code%TYPE;

Line 124: l_private_label okc_rules_b.Rule_information1%type;

120: l_func_curr_code OKL_EXT_SELL_INVS_B.currency_code%TYPE;
121:
122:
123: l_inf_id okl_invoice_formats_v.id%TYPE;
124: l_private_label okc_rules_b.Rule_information1%type;
125: -- End Bug 4540379
126:
127: -- For PPD process error reporting
128: l_overall_err_sts VARCHAR2(1);

Line 352: FROM okc_rules_b rule,

348:
349: -- Derive print lead days from the rules
350: CURSOR c_lead_days(p_khr_id IN NUMBER) IS
351: SELECT rule_information3
352: FROM okc_rules_b rule,
353: okc_rule_groups_b rgp
354: WHERE rgp.id = rule.rgp_id
355: AND rgp.dnz_chr_id = p_khr_id
356: AND rgd_code = 'LABILL'

Line 1324: FROM OKC_RULES_B rul,

1320:
1321: -- Receipt Method Or Payment method
1322: CURSOR cust_pmth_csr ( p_khr_id NUMBER ) IS
1323: SELECT object1_id1
1324: FROM OKC_RULES_B rul,
1325: Okc_rule_groups_B rgp
1326: WHERE rul.rgp_id = rgp.id AND
1327: rgp.rgd_code = 'LABILL' AND
1328: rgp.dnz_chr_id = rgp.chr_id AND

Line 1334: FROM OKC_RULES_B rul,

1330: rgp.dnz_chr_id = p_khr_id;
1331:
1332: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1333: SELECT object1_id1
1334: FROM OKC_RULES_B rul,
1335: Okc_rule_groups_B rgp
1336: WHERE rul.rgp_id = rgp.id AND
1337: rgp.rgd_code = 'LABILL' AND
1338: rgp.cle_id = p_kle_id AND

Line 1346: , OKC_RULES_B rul

1342: SELECT rul.object1_id1
1343: FROM okc_k_lines_b cle
1344: , okc_k_items_v item
1345: , okc_k_lines_b linked_asset
1346: , OKC_RULES_B rul
1347: , Okc_rule_groups_B rgp
1348: WHERE cle.dnz_chr_id = p_khr_id AND
1349: cle.id = p_kle_id AND
1350: cle.chr_id IS NULL AND

Line 1375: FROM OKC_RULES_B rul,

1371: M.receipt_method_id = p_rct_method_id;
1372:
1373: CURSOR cust_bank_csr ( p_khr_id NUMBER ) IS
1374: SELECT object1_id1
1375: FROM OKC_RULES_B rul,
1376: Okc_rule_groups_B rgp
1377: WHERE rul.rgp_id = rgp.id AND
1378: rgp.rgd_code = 'LABILL' AND
1379: rgp.dnz_chr_id = rgp.chr_id AND

Line 1385: FROM OKC_RULES_B rul,

1381: rgp.dnz_chr_id = p_khr_id;
1382:
1383: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1384: SELECT object1_id1
1385: FROM OKC_RULES_B rul,
1386: Okc_rule_groups_B rgp
1387: WHERE rul.rgp_id = rgp.id AND
1388: rgp.cle_id = p_kle_id AND
1389: rgp.rgd_code = 'LABILL' AND

Line 1397: , OKC_RULES_B rul

1393: SELECT rul.object1_id1
1394: FROM okc_k_lines_b cle
1395: , okc_k_items_v item
1396: , okc_k_lines_b linked_asset
1397: , OKC_RULES_B rul
1398: , Okc_rule_groups_B rgp
1399: WHERE cle.dnz_chr_id = p_khr_id AND
1400: cle.id = p_kle_id AND
1401: cle.chr_id IS NULL AND

Line 1514: okc_rules_b B

1510: -- -------------------------------------------
1511: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
1512: SELECT Rule_information1 PRIVATE_LABEL
1513: FROM okc_rule_groups_b A,
1514: okc_rules_b B
1515: WHERE A.DNZ_CHR_ID = CP_KHR_ID
1516: AND A.rgd_code = 'LALABL'
1517: AND A.id = B.rgp_id
1518: AND B.rule_information_category = 'LALOGO';

Line 1521: --l_private_label okc_rules_b.Rule_information1%type;

1517: AND A.id = B.rgp_id
1518: AND B.rule_information_category = 'LALOGO';
1519:
1520: -- Bug 4540379
1521: --l_private_label okc_rules_b.Rule_information1%type;
1522: -- End Bug 4540379
1523:
1524: -- to get inventory_org_id bug 4890024 begin
1525: CURSOR inv_org_id_csr ( p_khr_id NUMBER ) IS

Line 2528: , okc_rules_b rul

2524: AND kle.id (+) = stm.kle_id
2525: AND kls.code (+) = kle.sts_code
2526: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2527: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2528: , okc_rules_b rul
2529: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2530: AND rgp.cle_id = kle.id
2531: AND rgp.rgd_code = 'LAASTX'
2532: AND rgp.id = rul.rgp_id

Line 2588: , okc_rules_b rul

2584: AND kle.id (+) = stm.kle_id
2585: AND kls.code (+) = kle.sts_code
2586: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2587: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2588: , okc_rules_b rul
2589: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2590: AND rgp.cle_id = kle.id
2591: AND rgp.rgd_code = 'LAASTX'
2592: AND rgp.id = rul.rgp_id

Line 2749: , okc_rules_b rul

2745: AND kle.id (+) = stm.kle_id
2746: AND kls.code (+) = kle.sts_code
2747: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2748: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2749: , okc_rules_b rul
2750: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2751: AND rgp.cle_id = kle.id
2752: AND rgp.rgd_code = 'LAASTX'
2753: AND rgp.id = rul.rgp_id

Line 2809: , okc_rules_b rul

2805: AND kle.id (+) = stm.kle_id
2806: AND kls.code (+) = kle.sts_code
2807: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2808: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2809: , okc_rules_b rul
2810: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2811: AND rgp.cle_id = kle.id
2812: AND rgp.rgd_code = 'LAASTX'
2813: AND rgp.id = rul.rgp_id

Line 2978: , okc_rules_b rul

2974: AND kle.id (+) = stm.kle_id
2975: AND kls.code (+) = kle.sts_code
2976: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2977: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2978: , okc_rules_b rul
2979: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2980: AND rgp.cle_id = kle.id
2981: AND rgp.rgd_code = 'LAASTX'
2982: AND rgp.id = rul.rgp_id

Line 3041: , okc_rules_b rul

3037: AND kle.id (+) = stm.kle_id
3038: AND kls.code (+) = kle.sts_code
3039: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
3040: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
3041: , okc_rules_b rul
3042: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
3043: AND rgp.cle_id = kle.id
3044: AND rgp.rgd_code = 'LAASTX'
3045: AND rgp.id = rul.rgp_id