DBA Data[Home] [Help]

APPS.OE_MSG_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 1257: FROM oe_order_headers_all

1253: IF l_header_id IS NOT NULL
1254: AND NOT OE_GLOBALS.Equal(l_header_id,g_header_id) THEN
1255: SELECT order_number
1256: INTO l_order_number
1257: FROM oe_order_headers_all
1258: WHERE header_id = l_header_id;
1259: g_order_number := l_order_number;
1260: g_header_id := l_header_id;
1261:

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

1801: ELSIF p_process_activity_name is null
1802: THEN
1803:
1804: l_stmt := 'select transaction_id ' ||
1805: ' from oe_processing_msgs msg, oe_order_headers_all hdr';
1806:
1807: l_stmt := l_stmt ||' WHERE msg.header_id = hdr.header_id';
1808: ELSE
1809: