DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on RA_CUST_TRX_TYPES

Line 240: ,ra_cust_trx_types rtrx

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

Line 321: ,ra_cust_trx_types rtrx

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

Line 413: ,ra_cust_trx_types ct

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