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

Line 714: OKC_RULES_B crl,

710: p_cle_id NUMBER
711: ) IS
712: SELECT crl.id
713: FROM OKC_RULE_GROUPS_B crg,
714: OKC_RULES_B crl,
715: OKL_STRM_TYPE_B stty
716: WHERE stty.id = crl.object1_id1
717: AND stty.stream_type_purpose = 'PRINCIPAL_PAYMENT'
718: AND crl.rgp_id = crg.id

Line 726: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

722: and cle_id = p_cle_id;
723:
724: CURSOR l_pmnt_strm_check2(
725: rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
726: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
727: pmnt_strm_purpose OKL_STRM_TYPE_B.STREAM_TYPE_PURPOSE%TYPE,
728: chrId NUMBER) IS
729: SELECT crg.cle_id,
730: crl.id,

Line 741: OKC_RULES_B crl,

737: crl.RULE_INFORMATION6,
738: crl.RULE_INFORMATION10,
739: crl.RULE_INFORMATION11
740: FROM OKC_RULE_GROUPS_B crg,
741: OKC_RULES_B crl,
742: OKL_STRM_TYPE_B stty
743: WHERE stty.id = crl.object1_id1
744: AND stty.stream_type_purpose = pmnt_strm_purpose
745: AND crl.rgp_id = crg.id

Line 752: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE,

748: AND crg.dnz_chr_id = chrId;
749:
750: l_pmnt_strm_check_rec2 l_pmnt_strm_check2%ROWTYPE;
751:
752: CURSOR l_pmnt_lns_in_hdr(p_id OKC_RULES_B.ID%TYPE,
753: chrId NUMBER) IS
754: SELECT
755: crl2.object1_id1,
756: crl2.object1_id2,

Line 765: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

761: crl2.rule_information6,
762: crl2.rule_information7,
763: crl2.rule_information8,
764: crl2.rule_information10
765: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
766: WHERE crl1.id = crl2.object2_id1
767: AND crl1.id = p_id
768: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
769: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 775: CURSOR l_pmnt_lns_in_hdr2(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS

771: AND crl2.dnz_chr_id = chrId
772: ORDER BY crl2.rule_information2 ASC;
773:
774:
775: CURSOR l_pmnt_lns_in_hdr2(p_id OKC_RULES_B.ID%TYPE, chrId NUMBER) IS
776: SELECT
777: crl2.object1_id1,
778: crl2.object1_id2,
779: crl2.rule_information2,

Line 787: FROM OKC_RULES_B crl1, OKC_RULES_B crl2

783: crl2.rule_information6,
784: crl2.rule_information7,
785: crl2.rule_information8,
786: crl2.rule_information10
787: FROM OKC_RULES_B crl1, OKC_RULES_B crl2
788: WHERE crl1.id = crl2.object2_id1
789: AND crl1.id = p_id
790: AND crl2.RULE_INFORMATION_CATEGORY = 'LASLL'
791: AND crl1.RULE_INFORMATION_CATEGORY = 'LASLH'

Line 1685: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

1681: l_amount_tbl OKL_ACCOUNT_DIST_PVT.AMOUNT_TBL_TYPE;
1682: lx_template_tbl OKL_ACCOUNT_DIST_PUB.avlv_tbl_type;
1683: l_trx_desc VARCHAR2(2000);
1684: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1685: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1686: l_try_name VARCHAR2(30);
1687: l_trans_code VARCHAR2(30);
1688: l_tcn_type VARCHAR2(3);
1689: l_trans_meaning VARCHAR2(200);

Line 5961: FROM OKC_RULES_B rul

5957: -- Disable split asset process for
5958: -- Re-lease contract and Re-lease asset flows
5959: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
5960: SELECT '!'
5961: FROM OKC_RULES_B rul
5962: WHERE rul.dnz_chr_id = p_chr_id
5963: AND rul.rule_information_category = 'LARLES'
5964: AND NVL(rule_information1,'N') = 'Y';
5965:

Line 8768: FROM okc_rules_b rul,

8764: rul_slh.jtot_object1_code strm_type_source,
8765: rul_slh.object1_id1 strm_type_id1,
8766: rul_slh.object1_id2 strm_type_id2,
8767: cleb.currency_code
8768: FROM okc_rules_b rul,
8769: okc_rule_groups_b rgp,
8770: okc_rules_b rul_slh,
8771: okc_k_lines_b cleb
8772: --Bug# : 3124577 - 11.5.10 : Rule Migration

Line 8770: okc_rules_b rul_slh,

8766: rul_slh.object1_id2 strm_type_id2,
8767: cleb.currency_code
8768: FROM okc_rules_b rul,
8769: okc_rule_groups_b rgp,
8770: okc_rules_b rul_slh,
8771: okc_k_lines_b cleb
8772: --Bug# : 3124577 - 11.5.10 : Rule Migration
8773: WHERE rul.rule_information_category = 'LASLL'
8774: --where rul.rule_information_category = 'SLL'

Line 8793: FROM okc_rules_b rul

8789: SELECT rul.id slh_id,
8790: rul.jtot_object1_code strm_type_source,
8791: rul.object1_id1 strm_type_id1,
8792: rul.object1_id2 strm_type_id2
8793: FROM okc_rules_b rul
8794: WHERE rul.id = p_rul_id
8795: --Bug# - 3124577: 11.5.10 :---Rule Migration
8796: AND rul.rule_information_category = 'LASLH';
8797: --And rul.rule_information_category = 'SLH';

Line 8800: l_slh_rul_id okc_rules_b.id%TYPE;

8796: AND rul.rule_information_category = 'LASLH';
8797: --And rul.rule_information_category = 'SLH';
8798: */
8799:
8800: l_slh_rul_id okc_rules_b.id%TYPE;
8801: l_strm_type_source okc_rules_b.jtot_object1_code%TYPE;
8802: l_strm_type_id1 okc_rules_b.object1_id1%TYPE;
8803: l_strm_type_id2 okc_rules_b.object1_id2%TYPE;
8804:

Line 8801: l_strm_type_source okc_rules_b.jtot_object1_code%TYPE;

8797: --And rul.rule_information_category = 'SLH';
8798: */
8799:
8800: l_slh_rul_id okc_rules_b.id%TYPE;
8801: l_strm_type_source okc_rules_b.jtot_object1_code%TYPE;
8802: l_strm_type_id1 okc_rules_b.object1_id1%TYPE;
8803: l_strm_type_id2 okc_rules_b.object1_id2%TYPE;
8804:
8805:

Line 8802: l_strm_type_id1 okc_rules_b.object1_id1%TYPE;

8798: */
8799:
8800: l_slh_rul_id okc_rules_b.id%TYPE;
8801: l_strm_type_source okc_rules_b.jtot_object1_code%TYPE;
8802: l_strm_type_id1 okc_rules_b.object1_id1%TYPE;
8803: l_strm_type_id2 okc_rules_b.object1_id2%TYPE;
8804:
8805:
8806:

Line 8803: l_strm_type_id2 okc_rules_b.object1_id2%TYPE;

8799:
8800: l_slh_rul_id okc_rules_b.id%TYPE;
8801: l_strm_type_source okc_rules_b.jtot_object1_code%TYPE;
8802: l_strm_type_id1 okc_rules_b.object1_id1%TYPE;
8803: l_strm_type_id2 okc_rules_b.object1_id2%TYPE;
8804:
8805:
8806:
8807:

Line 8844: l_sll_id OKC_RULES_B.ID%TYPE;

8840: l_lty_code VARCHAR2(30);
8841: l_txdv_rec txdv_rec_type;
8842: l_txdv_rec_out txdv_rec_type;
8843:
8844: l_sll_id OKC_RULES_B.ID%TYPE;
8845: l_amount_sll OKC_RULES_B.Rule_Information6%TYPE;
8846: l_slh_id OKC_RULES_B.OBJECT2_ID1%TYPE;
8847: L_UPDATED_SLL_AMOUNT NUMBER;
8848: --Bug# 2757289 : For Payment stubs

Line 8845: l_amount_sll OKC_RULES_B.Rule_Information6%TYPE;

8841: l_txdv_rec txdv_rec_type;
8842: l_txdv_rec_out txdv_rec_type;
8843:
8844: l_sll_id OKC_RULES_B.ID%TYPE;
8845: l_amount_sll OKC_RULES_B.Rule_Information6%TYPE;
8846: l_slh_id OKC_RULES_B.OBJECT2_ID1%TYPE;
8847: L_UPDATED_SLL_AMOUNT NUMBER;
8848: --Bug# 2757289 : For Payment stubs
8849: l_updated_stub_amount NUMBER;

Line 8846: l_slh_id OKC_RULES_B.OBJECT2_ID1%TYPE;

8842: l_txdv_rec_out txdv_rec_type;
8843:
8844: l_sll_id OKC_RULES_B.ID%TYPE;
8845: l_amount_sll OKC_RULES_B.Rule_Information6%TYPE;
8846: l_slh_id OKC_RULES_B.OBJECT2_ID1%TYPE;
8847: L_UPDATED_SLL_AMOUNT NUMBER;
8848: --Bug# 2757289 : For Payment stubs
8849: l_updated_stub_amount NUMBER;
8850:

Line 8970: l_strm_type_id OKC_RULES_B.OBJECT1_ID1%TYPE;

8966: l_inv_item_id NUMBER;
8967: l_inv_org_id NUMBER;
8968:
8969: --Bug# 3897490
8970: l_strm_type_id OKC_RULES_B.OBJECT1_ID1%TYPE;
8971:
8972: --Bug# 3502142
8973: l_rounded_amount NUMBER;
8974: