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 109: l_addr_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

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

Line 110: l_pmth_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

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

Line 111: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;

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

Line 113: l_asst_tax OKC_RULES_B.rule_information1%TYPE;

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

Line 114: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;

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

Line 126: l_private_label okc_rules_b.Rule_information1%type;

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

Line 354: FROM okc_rules_b rule,

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

Line 1386: FROM OKC_RULES_B rul,

1382:
1383: -- Receipt Method Or Payment method
1384: CURSOR cust_pmth_csr ( p_khr_id NUMBER ) IS
1385: SELECT object1_id1
1386: FROM OKC_RULES_B rul,
1387: Okc_rule_groups_B rgp
1388: WHERE rul.rgp_id = rgp.id AND
1389: rgp.rgd_code = 'LABILL' AND
1390: rgp.dnz_chr_id = rgp.chr_id AND

Line 1396: FROM OKC_RULES_B rul,

1392: rgp.dnz_chr_id = p_khr_id;
1393:
1394: CURSOR cust_line_pmth_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1395: SELECT object1_id1
1396: FROM OKC_RULES_B rul,
1397: Okc_rule_groups_B rgp
1398: WHERE rul.rgp_id = rgp.id AND
1399: rgp.rgd_code = 'LABILL' AND
1400: rgp.cle_id = p_kle_id AND

Line 1408: , OKC_RULES_B rul

1404: SELECT rul.object1_id1
1405: FROM okc_k_lines_b cle
1406: , okc_k_items_v item
1407: , okc_k_lines_b linked_asset
1408: , OKC_RULES_B rul
1409: , Okc_rule_groups_B rgp
1410: WHERE cle.dnz_chr_id = p_khr_id AND
1411: cle.id = p_kle_id AND
1412: cle.chr_id IS NULL AND

Line 1437: FROM OKC_RULES_B rul,

1433: M.receipt_method_id = p_rct_method_id;
1434:
1435: CURSOR cust_bank_csr ( p_khr_id NUMBER ) IS
1436: SELECT object1_id1
1437: FROM OKC_RULES_B rul,
1438: Okc_rule_groups_B rgp
1439: WHERE rul.rgp_id = rgp.id AND
1440: rgp.rgd_code = 'LABILL' AND
1441: rgp.dnz_chr_id = rgp.chr_id AND

Line 1447: FROM OKC_RULES_B rul,

1443: rgp.dnz_chr_id = p_khr_id;
1444:
1445: CURSOR cust_line_bank_csr ( p_khr_id NUMBER, p_kle_id NUMBER ) IS
1446: SELECT object1_id1
1447: FROM OKC_RULES_B rul,
1448: Okc_rule_groups_B rgp
1449: WHERE rul.rgp_id = rgp.id AND
1450: rgp.cle_id = p_kle_id AND
1451: rgp.rgd_code = 'LABILL' AND

Line 1459: , OKC_RULES_B rul

1455: SELECT rul.object1_id1
1456: FROM okc_k_lines_b cle
1457: , okc_k_items_v item
1458: , okc_k_lines_b linked_asset
1459: , OKC_RULES_B rul
1460: , Okc_rule_groups_B rgp
1461: WHERE cle.dnz_chr_id = p_khr_id AND
1462: cle.id = p_kle_id AND
1463: cle.chr_id IS NULL AND

Line 1577: okc_rules_b B

1573: -- -------------------------------------------
1574: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
1575: SELECT Rule_information1 PRIVATE_LABEL
1576: FROM okc_rule_groups_b A,
1577: okc_rules_b B
1578: WHERE A.DNZ_CHR_ID = CP_KHR_ID
1579: AND A.rgd_code = 'LALABL'
1580: AND A.id = B.rgp_id
1581: AND B.rule_information_category = 'LALOGO';

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

1580: AND A.id = B.rgp_id
1581: AND B.rule_information_category = 'LALOGO';
1582:
1583: -- Bug 4540379
1584: --l_private_label okc_rules_b.Rule_information1%type;
1585: -- End Bug 4540379
1586:
1587: -- to get inventory_org_id bug 4890024 begin
1588: CURSOR inv_org_id_csr ( p_khr_id NUMBER ) IS

Line 2712: , okc_rules_b rul

2708: AND kle.id (+) = stm.kle_id
2709: AND kls.code (+) = kle.sts_code
2710: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2711: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2712: , okc_rules_b rul
2713: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2714: AND rgp.cle_id = kle.id
2715: AND rgp.rgd_code = 'LAASTX'
2716: AND rgp.id = rul.rgp_id

Line 2772: , okc_rules_b rul

2768: AND kle.id (+) = stm.kle_id
2769: AND kls.code (+) = kle.sts_code
2770: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2771: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2772: , okc_rules_b rul
2773: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2774: AND rgp.cle_id = kle.id
2775: AND rgp.rgd_code = 'LAASTX'
2776: AND rgp.id = rul.rgp_id

Line 2936: , okc_rules_b rul

2932: AND kle.id (+) = stm.kle_id
2933: AND kls.code (+) = kle.sts_code
2934: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2935: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2936: , okc_rules_b rul
2937: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2938: AND rgp.cle_id = kle.id
2939: AND rgp.rgd_code = 'LAASTX'
2940: AND rgp.id = rul.rgp_id

Line 2996: , okc_rules_b rul

2992: AND kle.id (+) = stm.kle_id
2993: AND kls.code (+) = kle.sts_code
2994: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
2995: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
2996: , okc_rules_b rul
2997: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
2998: AND rgp.cle_id = kle.id
2999: AND rgp.rgd_code = 'LAASTX'
3000: AND rgp.id = rul.rgp_id

Line 3168: , okc_rules_b rul

3164: AND kle.id (+) = stm.kle_id
3165: AND kls.code (+) = kle.sts_code
3166: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED', 'EXPIRED') -- Bug# 7475594
3167: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
3168: , okc_rules_b rul
3169: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
3170: AND rgp.cle_id = kle.id
3171: AND rgp.rgd_code = 'LAASTX'
3172: AND rgp.id = rul.rgp_id

Line 3231: , okc_rules_b rul

3227: AND kle.id (+) = stm.kle_id
3228: AND kls.code (+) = kle.sts_code
3229: AND NVL (kls.ste_code, 'ACTIVE') IN ('ACTIVE', 'TERMINATED')
3230: AND EXISTS (SELECT 1 FROM okc_rule_groups_b rgp
3231: , okc_rules_b rul
3232: WHERE rgp.dnz_chr_id = kle.dnz_chr_id
3233: AND rgp.cle_id = kle.id
3234: AND rgp.rgd_code = 'LAASTX'
3235: AND rgp.id = rul.rgp_id