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

Line 146: rlcat okc_rules_b.rule_information_category%TYPE,

142: FROM okl_streams lsm
143: WHERE lsm.khr_id = khrid;
144: -- get the Header rule information
145: CURSOR l_hdrrl_csr(rgcode okc_rule_groups_b.rgd_code%TYPE,
146: rlcat okc_rules_b.rule_information_category%TYPE,
147: chrId NUMBER)
148: IS
149: SELECT crl.object1_id1,
150: crl.rule_information1,

Line 160: okc_rules_b crl

156: crl.rule_information10,
157: crl.rule_information13,
158: crl.rule_information11
159: FROM okc_rule_groups_b crg,
160: okc_rules_b crl
161: WHERE crl.rgp_id = crg.id
162: AND crg.rgd_code = rgcode
163: AND crl.rule_information_category = rlcat
164: AND crg.dnz_chr_id = chrId;

Line 168: rlcat okc_rules_b.rule_information_category%TYPE,

164: AND crg.dnz_chr_id = chrId;
165: -- get the self referencing Line based rule information
166: CURSOR l_rl_csr(rlgpId NUMBER,
167: rgcode okc_rule_groups_b.rgd_code%TYPE,
168: rlcat okc_rules_b.rule_information_category%TYPE,
169: chrId NUMBER,
170: cleId NUMBER )
171: IS
172: SELECT crl.object1_id1,

Line 186: okc_rules_b crl

182: crl.rule_information13,
183: crl.rule_information10,
184: DECODE(crl.object1_id1,'M',1,'Q',3,'S',6,'A',12) decoded_object1_id1
185: FROM okc_rule_groups_b crg,
186: okc_rules_b crl
187: WHERE crl.rgp_id = crg.id
188: AND crl.object2_id1 = rlgpId
189: AND crg.rgd_code = rgcode
190: AND crl.rule_information_category = rlcat

Line 199: rlcat okc_rules_b.rule_information_category%TYPE,

195: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
196: --end bug#2757289 bakuchib
197: -- get the Line rule information
198: CURSOR l_rl_csr2(rgcode okc_rule_groups_b.rgd_code%TYPE,
199: rlcat okc_rules_b.rule_information_category%TYPE,
200: chrId NUMBER,
201: cleId NUMBER)
202: IS
203: SELECT crl.id slh_id,

Line 217: okc_rules_b crl

213: crl.rule_information13,
214: --end bug#2757289 bakuchib
215: crl.rule_information10
216: FROM okc_rule_groups_b crg,
217: okc_rules_b crl
218: WHERE crl.rgp_id = crg.id
219: AND crg.rgd_code = rgcode
220: AND crl.rule_information_category = rlcat
221: AND crg.dnz_chr_id = chrId

Line 226: rlcat okc_rules_b.rule_information_category%TYPE,

222: AND crg.cle_id = cleId
223: ORDER BY crl.rule_information1;
224: -- get the Line rule information
225: CURSOR l_rl_csr1(rgcode okc_rule_groups_b.rgd_code%TYPE,
226: rlcat okc_rules_b.rule_information_category%TYPE,
227: chrId NUMBER,
228: cleId NUMBER )
229: IS
230: SELECT crl.id slh_id,

Line 244: okc_rules_b crl

240: crl.rule_information13,
241: --end bug#2757289 bakuchib
242: crl.rule_information10
243: FROM okc_rule_groups_b crg,
244: okc_rules_b crl
245: WHERE crl.rgp_id = crg.id
246: AND crg.rgd_code = rgcode
247: AND crl.rule_information_category = rlcat
248: AND crg.dnz_chr_id = chrId