APPS.OKL_LTE_CHRG_PVT dependencies on OKC_RULES_B

Line 122: ,okc_rules_b rul

118: and RACTRX.ORG_ID = RATRXTYPE.ORG_ID ) lpt
119: ,okl_bpd_ar_inv_lines_v lpt1
120: ,okl_k_headers_full_v khr
121: ,okc_rule_groups_b rgp
122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm
124: ,okc_rules_b rul_hld
125: ,okl_late_policies_v lte
126: ,okl_strm_type_b stb --For bug 7356486

Line 123: ,okc_rules_b rul_exm

119: ,okl_bpd_ar_inv_lines_v lpt1
120: ,okl_k_headers_full_v khr
121: ,okc_rule_groups_b rgp
122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm
124: ,okc_rules_b rul_hld
125: ,okl_late_policies_v lte
126: ,okl_strm_type_b stb --For bug 7356486
127: where lpt.invoice_id=lpt1.invoice_id

Line 124: ,okc_rules_b rul_hld

120: ,okl_k_headers_full_v khr
121: ,okc_rule_groups_b rgp
122: ,okc_rules_b rul
123: ,okc_rules_b rul_exm
124: ,okc_rules_b rul_hld
125: ,okl_late_policies_v lte
126: ,okl_strm_type_b stb --For bug 7356486
127: where lpt.invoice_id=lpt1.invoice_id
128: and lpt.pay_sch_class = 'INV'

Line 180: ,okc_rules_b rul

176: ,OKL_CNSLD_AR_LINES_B LN
177: ,OKL_STRM_TYPE_B SM
178: ,okl_k_headers_full_v khr
179: ,okc_rule_groups_b rgp
180: ,okc_rules_b rul
181: ,okc_rules_b rul_exm
182: ,okc_rules_b rul_hld
183: ,okl_late_policies_v lte
184: where PS.CLASS IN ('INV', 'CM')

Line 181: ,okc_rules_b rul_exm

177: ,OKL_STRM_TYPE_B SM
178: ,okl_k_headers_full_v khr
179: ,okc_rule_groups_b rgp
180: ,okc_rules_b rul
181: ,okc_rules_b rul_exm
182: ,okc_rules_b rul_hld
183: ,okl_late_policies_v lte
184: where PS.CLASS IN ('INV', 'CM')
185: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID

Line 182: ,okc_rules_b rul_hld

178: ,okl_k_headers_full_v khr
179: ,okc_rule_groups_b rgp
180: ,okc_rules_b rul
181: ,okc_rules_b rul_exm
182: ,okc_rules_b rul_hld
183: ,okl_late_policies_v lte
184: where PS.CLASS IN ('INV', 'CM')
185: AND ST.RECEIVABLES_INVOICE_ID = PS.CUSTOMER_TRX_ID
186: AND LN.ID = ST.LLN_ID

Line 268: ,okc_rules_b rul

264: ,okl_bpd_ar_inv_lines_v last_arl
265: ,okl_strm_elements_v sel
266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul
269: ,okc_rules_b rul_exm
270: ,okc_rules_b rul_hld
271: ,okl_late_policies_v lte
272: WHERE last_arl.sel_id = sel.id

Line 269: ,okc_rules_b rul_exm

265: ,okl_strm_elements_v sel
266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul
269: ,okc_rules_b rul_exm
270: ,okc_rules_b rul_hld
271: ,okl_late_policies_v lte
272: WHERE last_arl.sel_id = sel.id
273: and orig_arv.pay_sch_class = 'INV'

Line 270: ,okc_rules_b rul_hld

266: ,okl_k_headers_full_v khr
267: ,okc_rule_groups_b rgp
268: ,okc_rules_b rul
269: ,okc_rules_b rul_exm
270: ,okc_rules_b rul_hld
271: ,okl_late_policies_v lte
272: WHERE last_arl.sel_id = sel.id
273: and orig_arv.pay_sch_class = 'INV'
274: AND orig_arv.STATUS = 'OP'

Line 375: ,okc_rules_b rul

371: AND SM.ID = ST.STY_ID) last
372: ,okl_strm_elements_v sel
373: ,okl_k_headers_full_v khr
374: ,okc_rule_groups_b rgp
375: ,okc_rules_b rul
376: ,okc_rules_b rul_exm
377: ,okc_rules_b rul_hld
378: ,okl_late_policies_v lte
379: where last.sel_id = sel.id

Line 376: ,okc_rules_b rul_exm

372: ,okl_strm_elements_v sel
373: ,okl_k_headers_full_v khr
374: ,okc_rule_groups_b rgp
375: ,okc_rules_b rul
376: ,okc_rules_b rul_exm
377: ,okc_rules_b rul_hld
378: ,okl_late_policies_v lte
379: where last.sel_id = sel.id
380: and orig.class = 'INV'

Line 377: ,okc_rules_b rul_hld

373: ,okl_k_headers_full_v khr
374: ,okc_rule_groups_b rgp
375: ,okc_rules_b rul
376: ,okc_rules_b rul_exm
377: ,okc_rules_b rul_hld
378: ,okl_late_policies_v lte
379: where last.sel_id = sel.id
380: and orig.class = 'INV'
381: and orig.status = 'OP'