DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_CREDIT_CHECK_RULES

Line 238: ,oe_credit_check_rules rl

234: ,oe_ar_lookups_v fp
235: ,oe_lookups ft
236: ,oe_fnd_common_lookups_v dc
237: ,oe_transaction_types_all lt
238: ,oe_credit_check_rules rl
239: ,ra_cust_trx_types rtrx
240: WHERE o.transaction_type_id = p_key
241: AND o.invoicing_rule_id = i.rule_id(+)
242: AND i.status(+) = 'A'

Line 319: ,oe_credit_check_rules rl

315: ,G_ORDER_TYPE_TBL(p_key).tax_calculation_flag
316: ,G_ORDER_TYPE_TBL(p_key).cust_trx_type_id
317: FROM OE_TRANSACTION_TYPES_ALL o
318: ,oe_transaction_types_tl otl
319: ,oe_credit_check_rules rl
320: ,ra_cust_trx_types rtrx
321: WHERE o.transaction_type_id = p_key
322: AND otl.transaction_type_id = o.transaction_type_id
323: AND otl.language = userenv('LANG')