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: where lpt.invoice_id=lpt1.invoice_id

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: where lpt.invoice_id=lpt1.invoice_id
127: and lpt.pay_sch_class = 'INV'

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: where lpt.invoice_id=lpt1.invoice_id
127: and lpt.pay_sch_class = 'INV'
128: AND lpt.STATUS = 'OP'

Line 176: ,okc_rules_b rul

172: ,OKL_CNSLD_AR_LINES_B LN
173: ,OKL_STRM_TYPE_B SM
174: ,okl_k_headers_full_v khr
175: ,okc_rule_groups_b rgp
176: ,okc_rules_b rul
177: ,okc_rules_b rul_exm
178: ,okc_rules_b rul_hld
179: ,okl_late_policies_v lte
180: where PS.CLASS IN ('INV', 'CM')

Line 177: ,okc_rules_b rul_exm

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

Line 178: ,okc_rules_b rul_hld

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

Line 263: ,okc_rules_b rul

259: ,okl_bpd_ar_inv_lines_v last_arl
260: ,okl_strm_elements_v sel
261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul
264: ,okc_rules_b rul_exm
265: ,okc_rules_b rul_hld
266: ,okl_late_policies_v lte
267: WHERE last_arl.sel_id = sel.id

Line 264: ,okc_rules_b rul_exm

260: ,okl_strm_elements_v sel
261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul
264: ,okc_rules_b rul_exm
265: ,okc_rules_b rul_hld
266: ,okl_late_policies_v lte
267: WHERE last_arl.sel_id = sel.id
268: and orig_arv.pay_sch_class = 'INV'

Line 265: ,okc_rules_b rul_hld

261: ,okl_k_headers_full_v khr
262: ,okc_rule_groups_b rgp
263: ,okc_rules_b rul
264: ,okc_rules_b rul_exm
265: ,okc_rules_b rul_hld
266: ,okl_late_policies_v lte
267: WHERE last_arl.sel_id = sel.id
268: and orig_arv.pay_sch_class = 'INV'
269: AND orig_arv.STATUS = 'OP'

Line 370: ,okc_rules_b rul

366: AND SM.ID = ST.STY_ID) last
367: ,okl_strm_elements_v sel
368: ,okl_k_headers_full_v khr
369: ,okc_rule_groups_b rgp
370: ,okc_rules_b rul
371: ,okc_rules_b rul_exm
372: ,okc_rules_b rul_hld
373: ,okl_late_policies_v lte
374: where last.sel_id = sel.id

Line 371: ,okc_rules_b rul_exm

367: ,okl_strm_elements_v sel
368: ,okl_k_headers_full_v khr
369: ,okc_rule_groups_b rgp
370: ,okc_rules_b rul
371: ,okc_rules_b rul_exm
372: ,okc_rules_b rul_hld
373: ,okl_late_policies_v lte
374: where last.sel_id = sel.id
375: and orig.class = 'INV'

Line 372: ,okc_rules_b rul_hld

368: ,okl_k_headers_full_v khr
369: ,okc_rule_groups_b rgp
370: ,okc_rules_b rul
371: ,okc_rules_b rul_exm
372: ,okc_rules_b rul_hld
373: ,okl_late_policies_v lte
374: where last.sel_id = sel.id
375: and orig.class = 'INV'
376: and orig.status = 'OP'