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

Line 1874: from okc_rules_b rul, okc_rule_groups_b rgp

1870: select rul.jtot_object1_code,rul.object1_id1,rul.object1_id2
1871: ,rul.jtot_object2_code,rul.object2_id1,rul.object2_id2
1872: ,rul.jtot_object3_code,rul.object3_id1,rul.object3_id2
1873: ,rul.rule_information_category
1874: from okc_rules_b rul, okc_rule_groups_b rgp
1875: where rul.rgp_id = rgp.id and
1876: rgp.rgd_code in ('BILLING','SHIPPING','PAYMENT') and
1877: rul.rule_information_category in ('BTO','STO','PTR','CAN') and
1878: rgp.dnz_chr_id = p_chr_id and rgp.chr_id is not null;

Line 1889: from okc_rules_b rul, okc_rule_groups_b rgp

1885: --rul.rule_information3,rul.rule_information4,rul.rule_information5,rul.rule_information6,
1886: --rul.rule_information7,rul.rule_information8,rul.rule_information9,rul.rule_information10,
1887: --rul.rule_information11,rul.rule_information12,rul.rule_information13,rul.rule_information14,
1888: --rul.rule_information15
1889: from okc_rules_b rul, okc_rule_groups_b rgp
1890: where rul.rgp_id = rgp.id and rgp.chr_id = p_chr_id;*/
1891:
1892: cursor l_cle_rul_csr(p_chr_id IN NUMBER,p_cle_id IN NUMBER) Is
1893:

Line 1901: from okc_rules_b rul, okc_rule_groups_b rgp

1897: ,rul.jtot_object2_code,rul.object2_id1,rul.object2_id2
1898: ,rul.jtot_object3_code,rul.object3_id1,rul.object3_id2
1899: ,rul.rule_information_category
1900:
1901: from okc_rules_b rul, okc_rule_groups_b rgp
1902: where rul.rgp_id = rgp.id and rgp.dnz_chr_id = p_chr_id and
1903: rgp.cle_id=p_cle_id and
1904: rgp.rgd_code in ('BILLING','SHIPPING','PAYMENT') and
1905: rul.rule_information_category in ('BTO','STO','PTR','CAN');

Line 1915: from okc_rules_b rul, okc_rule_groups_b rgp

1911: --rul.rule_information3,rul.rule_information4,rul.rule_information5,rul.rule_information6,
1912: --rul.rule_information7,rul.rule_information8,rul.rule_information9,rul.rule_information10,
1913: --rul.rule_information11,rul.rule_information12,rul.rule_information13,rul.rule_information14,
1914: --rul.rule_information15
1915: from okc_rules_b rul, okc_rule_groups_b rgp
1916: where rul.rgp_id = rgp.id and rgp.dnz_chr_id = p_chr_id and rgp.cle_id=p_cle_id;*/
1917:
1918: l_return_status varchar2(1):=OKC_API.G_RET_STS_SUCCESS;
1919: l_rul_rec global_rprle_rec_type;