eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on MTL_SALES_ORDERS

Line 3757: from mtl_sales_orders

3753: end if;
3754: if P_from_sales_order_id is not null then
3755: select lpad(segment1,40), segment2,segment1
3756: INTO l_from_tonum_mso_seg1,l_from_mso_seg2,l_from_mso_seg1
3757: from mtl_sales_orders
3758: WHERE sales_order_id = p_from_sales_order_id;
3759: end if;
3760: IF(l_is_range_so) THEN
3761: /* Its a range...Query for details of to sales order */

Line 3765: from mtl_sales_orders

3761: /* Its a range...Query for details of to sales order */
3762: if P_to_sales_order_id is not null then
3763: select lpad(segment1,40), segment2
3764: INTO l_to_tonum_mso_seg1,l_to_mso_seg2
3765: from mtl_sales_orders
3766: WHERE sales_order_id = p_to_sales_order_id;
3767: end if;/*added the above code to get the values since we are not going to join with mso 3455109*/
3768: ELSE
3769: l_to_tonum_mso_seg1 := l_from_tonum_mso_seg1;

Line 4084: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso1 ';

4080:
4081: if (i =1) then/*3455109 we will no longer use mso for completed tasks*/
4082: IF p_from_sales_order_id IS NOT NULL
4083: THEN
4084: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso1 ';
4085: END IF;
4086:
4087: IF p_to_sales_order_id IS NOT NULL
4088: THEN

Line 4089: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso2 ';

4085: END IF;
4086:
4087: IF p_to_sales_order_id IS NOT NULL
4088: THEN
4089: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso2 ';
4090: END IF;
4091: END IF;
4092:
4093: IF g_customer_visible = 'T' OR p_customer_category IS NOT NULL