DBA Data[Home] [Help]

APPS.OE_MSG_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1219: FROM oe_order_headers_all

1215: IF l_header_id IS NOT NULL
1216: AND NOT OE_GLOBALS.Equal(l_header_id,g_header_id) THEN
1217: SELECT order_number
1218: INTO l_order_number
1219: FROM oe_order_headers_all
1220: WHERE header_id = l_header_id;
1221: g_order_number := l_order_number;
1222: g_header_id := l_header_id;
1223:

Line 1766: ' from oe_processing_msgs msg, oe_order_headers_all hdr';

1762: ELSIF p_process_activity_name is null
1763: THEN
1764:
1765: l_stmt := 'select transaction_id ' ||
1766: ' from oe_processing_msgs msg, oe_order_headers_all hdr';
1767:
1768: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id';
1769: ELSE
1770: