DBA Data[Home] [Help]

APPS.OE_ELECMSGS_PVT dependencies on OE_ORDER_SOURCES

Line 240: FROM OE_Order_Sources;

236:
237: IF p_order_source_id IS NULL THEN
238: SELECT max(order_source_id), min(order_source_id)
239: INTO l_max_order_source_id, l_min_order_source_id
240: FROM OE_Order_Sources;
241: END IF;
242:
243: IF p_order_source_id IS NOT NULL
244: AND p_sold_to_org_id IS NOT NULL THEN

Line 1312: FROM OE_Order_Sources;

1308: IF p_view_name IN ('OE_HEADERS_INTERFACE', 'OE_LINES_INTERFACE','OE_EM_INFORMATION') THEN
1309:
1310: SELECT max(order_source_id), min(order_source_id)
1311: INTO l_max_order_source_id, l_min_order_source_id
1312: FROM OE_Order_Sources;
1313:
1314: IF l_debug_level > 0 THEN
1315: oe_debug_pub.add('Fetched min order source id ' || l_min_order_source_id || ' and max order source id ' || l_max_order_source_id);
1316: END IF;