DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_TRANSACTION_TYPES_TL

Line 228: ,oe_transaction_types_tl otl

224: ,G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag
225: ,G_ORDER_TYPE_TBL(p_key).tax_calculation_flag
226: ,G_ORDER_TYPE_TBL(p_key).cust_trx_type_id
227: FROM oe_transaction_types_all o
228: ,oe_transaction_types_tl otl
229: ,oe_ra_rules_v i
230: ,oe_ra_rules_v a
231: ,qp_list_headers_vl pl
232: ,oe_lookups sp

Line 318: ,oe_transaction_types_tl otl

314: ,G_ORDER_TYPE_TBL(p_key).quick_cr_check_flag
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