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 4286: from mtl_sales_orders

4282: end if;
4283: if P_from_sales_order_id is not null then
4284: select lpad(segment1,40), segment2,segment1
4285: INTO l_from_tonum_mso_seg1,l_from_mso_seg2,l_from_mso_seg1
4286: from mtl_sales_orders
4287: WHERE sales_order_id = p_from_sales_order_id;
4288: end if;
4289: IF(l_is_range_so) THEN
4290: /* Its a range...Query for details of to sales order */

Line 4294: from mtl_sales_orders

4290: /* Its a range...Query for details of to sales order */
4291: if P_to_sales_order_id is not null then
4292: select lpad(segment1,40), segment2
4293: INTO l_to_tonum_mso_seg1,l_to_mso_seg2
4294: from mtl_sales_orders
4295: WHERE sales_order_id = p_to_sales_order_id;
4296: end if;/*added the above code to get the values since we are not going to join with mso 3455109*/
4297: ELSE
4298: l_to_tonum_mso_seg1 := l_from_tonum_mso_seg1;

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

4709:
4710: if (i =1 OR i=3) then/*3455109 we will no longer use mso for completed tasks*/
4711: IF p_from_sales_order_id IS NOT NULL
4712: THEN
4713: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso1 ';
4714: END IF;
4715:
4716: IF p_to_sales_order_id IS NOT NULL
4717: THEN

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

4714: END IF;
4715:
4716: IF p_to_sales_order_id IS NOT NULL
4717: THEN
4718: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso2 ';
4719: END IF;
4720: END IF;
4721:
4722: IF g_customer_visible = 'T' OR p_customer_category IS NOT NULL