APPS.OZF_RESALE_COMMON_PVT dependencies on OE_TRANSACTION_TYPES_ALL
Line 454: FROM oe_transaction_types_all ottv
450: AND orsl.direct_customer_flag = 'T'
451: AND orsl.order_type_id IS NOT NULL
452: AND orsl.resale_batch_id = p_resale_batch_id
453: AND NOT EXISTS ( SELECT 1 454: FROM oe_transaction_types_all ottv 455: WHERE ottv.transaction_type_id = orsl.order_type_id)
456: UNION ALL
457: /*
458: SELECT orsl.resale_line_int_id