DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_SALES_ORDERS

Line 575: from msc_sales_orders mso

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