APPS.WMS_PLAN_TASKS_PVT dependencies on MTL_SALES_ORDERS

Line 578: from mtl_sales_orders

574: end if;
575: if wms_plan_tasks_pvt.g_from_sales_order_id is not null then
576: select lpad(segment1,40), segment2,segment1
577: INTO l_from_tonum_mso_seg1,l_from_mso_seg2,l_from_mso_seg1
578: from mtl_sales_orders
579: WHERE sales_order_id = wms_plan_tasks_pvt.g_from_sales_order_id;
580: end if;
581: IF(l_is_range_so) THEN
582: /* Its a range...Query for details of to sales order */

Line 586: from mtl_sales_orders

582: /* Its a range...Query for details of to sales order */
583: if wms_plan_tasks_pvt.g_to_sales_order_id is not null then
584: select lpad(segment1,40), segment2
585: INTO l_to_tonum_mso_seg1,l_to_mso_seg2
586: from mtl_sales_orders
587: WHERE sales_order_id = wms_plan_tasks_pvt.g_to_sales_order_id;
588: end if;/*added the above code to get the values since we are not going to join with mso 3455109*/
589: ELSE
590: l_to_tonum_mso_seg1 := l_from_tonum_mso_seg1;

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

3287: l_from_outbound := ', wsh_delivery_details_ob_grp_v wdd ';
3288: if NOT g_is_completed_task then/*3455109 we will no longer use mso for completed tasks*/
3289: IF wms_plan_tasks_pvt.g_from_sales_order_id IS NOT NULL
3290: THEN
3291: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso1 ';
3292: END IF;
3293:
3294: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL
3295: THEN

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

3292: END IF;
3293:
3294: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL
3295: THEN
3296: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso2 ';
3297: END IF;
3298: END IF;
3299:
3300: IF g_customer_visible = 'T' OR wms_plan_tasks_pvt.g_customer_category IS NOT NULL