APPS.OE_BULK_CACHE dependencies on RA_CUST_TRX_TYPES

Line 239: ,ra_cust_trx_types rtrx

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'
243: AND i.type(+) = 'I'

Line 320: ,ra_cust_trx_types rtrx

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')
324: AND o.entry_credit_check_rule_id = rl.credit_check_rule_id(+)

Line 412: ,ra_cust_trx_types ct

408: ,G_LINE_TYPE_TBL(p_key).cust_trx_type_id
409: ,G_LINE_TYPE_TBL(p_key).tax_calculation_flag
410: ,G_LINE_TYPE_TBL(p_key).scheduling_level_code
411: FROM oe_transaction_types_all o
412: ,ra_cust_trx_types ct
413: WHERE o.transaction_type_id = p_key
414: AND o.cust_trx_type_id = ct.cust_trx_type_id(+);
415:
416: RETURN p_key;