APPS.OZF_RESALE_COMMON_PVT dependencies on OE_TRANSACTION_TYPES_ALL

Line 440: FROM oe_transaction_types_all ottv

436: AND orsl.direct_customer_flag = 'T'
437: AND orsl.order_type_id IS NOT NULL
438: AND orsl.resale_batch_id = p_resale_batch_id
439: AND NOT EXISTS ( SELECT 1
440: FROM oe_transaction_types_all ottv
441: WHERE ottv.transaction_type_id = orsl.order_type_id)
442: UNION ALL
443: /*
444: SELECT orsl.resale_line_int_id