APPS.WMS_PLAN_TASKS_PVT dependencies on MTL_SALES_ORDERS

Line 554: from mtl_sales_orders

550: end if;
551: if wms_plan_tasks_pvt.g_from_sales_order_id is not null then
552: select lpad(segment1,40), segment2,segment1
553: INTO l_from_tonum_mso_seg1,l_from_mso_seg2,l_from_mso_seg1
554: from mtl_sales_orders
555: WHERE sales_order_id = wms_plan_tasks_pvt.g_from_sales_order_id;
556: end if;
557: IF(l_is_range_so) THEN
558: /* Its a range...Query for details of to sales order */

Line 562: from mtl_sales_orders

558: /* Its a range...Query for details of to sales order */
559: if wms_plan_tasks_pvt.g_to_sales_order_id is not null then
560: select lpad(segment1,40), segment2
561: INTO l_to_tonum_mso_seg1,l_to_mso_seg2
562: from mtl_sales_orders
563: WHERE sales_order_id = wms_plan_tasks_pvt.g_to_sales_order_id;
564: end if;/*added the above code to get the values since we are not going to join with mso 3455109*/
565: ELSE
566: l_to_tonum_mso_seg1 := l_from_tonum_mso_seg1;

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

3178: l_from_outbound := ', wsh_delivery_details_ob_grp_v wdd ';
3179: if NOT g_is_completed_task then/*3455109 we will no longer use mso for completed tasks*/
3180: IF wms_plan_tasks_pvt.g_from_sales_order_id IS NOT NULL
3181: THEN
3182: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso1 ';
3183: END IF;
3184:
3185: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL
3186: THEN

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

3183: END IF;
3184:
3185: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL
3186: THEN
3187: l_from_outbound := l_from_outbound || ', mtl_sales_orders mso2 ';
3188: END IF;
3189: END IF;
3190:
3191: IF g_customer_visible = 'T' OR wms_plan_tasks_pvt.g_customer_category IS NOT NULL