DBA Data[Home] [Help]

APPS.OE_MESSAGE_PURGE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 47: FROM oe_processing_msgs m, oe_order_headers_all o

43: o.order_number,
44: o.order_type_id,
45: o.sold_to_org_id,
46: m.message_status_code
47: FROM oe_processing_msgs m, oe_order_headers_all o
48: WHERE m.header_id = o.header_id (+)
49: AND NVL(m.message_source_code, 'NULL') =
50: NVL(p_message_source, NVL(m.message_source_code, 'NULL'))
51: AND TRUNC(m.creation_date) BETWEEN NVL(l_start, TRUNC(m.creation_date))