DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKC_RULES_B

Line 130: , OKC_RULES_B RUL

126: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
127: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
128: , OKL_K_HEADERS_FULL_V KHR
129: , OKC_RULE_GROUPS_B RGP
130: , OKC_RULES_B RUL
131: , okc_rules_b rul_exm
132: ,okc_rules_b rul_hld
133: , OKL_LATE_POLICIES_V LTE
134: , AR_CASH_RECEIPTS_ALL CRA

Line 131: , okc_rules_b rul_exm

127: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
128: , OKL_K_HEADERS_FULL_V KHR
129: , OKC_RULE_GROUPS_B RGP
130: , OKC_RULES_B RUL
131: , okc_rules_b rul_exm
132: ,okc_rules_b rul_hld
133: , OKL_LATE_POLICIES_V LTE
134: , AR_CASH_RECEIPTS_ALL CRA
135: , RA_CUSTOMER_TRX_LINES_ALL RACTRL

Line 132: ,okc_rules_b rul_hld

128: , OKL_K_HEADERS_FULL_V KHR
129: , OKC_RULE_GROUPS_B RGP
130: , OKC_RULES_B RUL
131: , okc_rules_b rul_exm
132: ,okc_rules_b rul_hld
133: , OKL_LATE_POLICIES_V LTE
134: , AR_CASH_RECEIPTS_ALL CRA
135: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
136: , OKL_TXD_AR_LN_DTLS_B TXD

Line 203: , OKC_RULES_B RUL

199: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC
200: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
201: , OKL_K_HEADERS_FULL_V KHR
202: , OKC_RULE_GROUPS_B RGP
203: , OKC_RULES_B RUL
204: , okc_rules_b rul_exm
205: ,okc_rules_b rul_hld
206: , OKL_LATE_POLICIES_V LTE
207: , AR_CASH_RECEIPTS_ALL CRA

Line 204: , okc_rules_b rul_exm

200: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
201: , OKL_K_HEADERS_FULL_V KHR
202: , OKC_RULE_GROUPS_B RGP
203: , OKC_RULES_B RUL
204: , okc_rules_b rul_exm
205: ,okc_rules_b rul_hld
206: , OKL_LATE_POLICIES_V LTE
207: , AR_CASH_RECEIPTS_ALL CRA
208: , RA_CUSTOMER_TRX_LINES_ALL RACTRL

Line 205: ,okc_rules_b rul_hld

201: , OKL_K_HEADERS_FULL_V KHR
202: , OKC_RULE_GROUPS_B RGP
203: , OKC_RULES_B RUL
204: , okc_rules_b rul_exm
205: ,okc_rules_b rul_hld
206: , OKL_LATE_POLICIES_V LTE
207: , AR_CASH_RECEIPTS_ALL CRA
208: , RA_CUSTOMER_TRX_LINES_ALL RACTRL
209: , RA_CUSTOMER_TRX_LINES_ALL RACTRL_TAX

Line 289: , OKC_RULES_B RUL

285: , AR_PAYMENT_SCHEDULES_ALL AR_PAY
286: , OKL_CNSLD_AR_STRMS_B CNSLD
287: , OKL_K_HEADERS_FULL_V KHR
288: , OKC_RULE_GROUPS_B RGP
289: , OKC_RULES_B RUL
290: , okc_rules_b rul_exm
291: ,okc_rules_b rul_hld
292: , OKL_LATE_POLICIES_V LTE
293: , AR_CASH_RECEIPTS_ALL CRA

Line 290: , okc_rules_b rul_exm

286: , OKL_CNSLD_AR_STRMS_B CNSLD
287: , OKL_K_HEADERS_FULL_V KHR
288: , OKC_RULE_GROUPS_B RGP
289: , OKC_RULES_B RUL
290: , okc_rules_b rul_exm
291: ,okc_rules_b rul_hld
292: , OKL_LATE_POLICIES_V LTE
293: , AR_CASH_RECEIPTS_ALL CRA
294: WHERE

Line 291: ,okc_rules_b rul_hld

287: , OKL_K_HEADERS_FULL_V KHR
288: , OKC_RULE_GROUPS_B RGP
289: , OKC_RULES_B RUL
290: , okc_rules_b rul_exm
291: ,okc_rules_b rul_hld
292: , OKL_LATE_POLICIES_V LTE
293: , AR_CASH_RECEIPTS_ALL CRA
294: WHERE
295: CRA.RECEIPT_DATE > (AR_PAY.DUE_DATE + nvl(LTE.late_int_grace_period, 0)) AND