DBA Data[Home] [Help]

APPS.OE_BULK_CACHE dependencies on OE_TRANSACTION_TYPES_TL

Line 229: ,oe_transaction_types_tl otl

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

Line 319: ,oe_transaction_types_tl otl

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