DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_SALES_ORDERS

Line 572: from msc_sales_orders mso

568: nvl(dem.task_id, -99) = nvl(p_task_id, nvl(dem.task_id, -99)) and
569: dem.dmd_satisfied_date between nvl(p_horizon_start, dem.dmd_satisfied_date)
570: and nvl(p_horizon_end, dem.dmd_satisfied_date)
571: and exists ( select 'PICK_ONLY_UNSHIPPED_ISO'
572: from msc_sales_orders mso
573: where mso.demand_id = dem.demand_id
574: and mso.sr_instance_id = dem.sr_instance_id
575: and (mso.primary_uom_quantity - mso.completed_quantity) > 0 )
576: and mpb.plan_id = dem.plan_id