DBA Data[Home] [Help]

APPS.FLM_LINEARITY_REPORT dependencies on WIP_SCHEDULE_GROUPS

Line 23: FROM wip_flow_schedules wfs, wip_lines wl, wip_schedule_groups wsg

19: wfs.primary_item_id,
20: trunc(wfs.scheduled_completion_date),
21: sum(nvl(wfs.planned_quantity,0)),
22: sum(nvl(wfs.quantity_completed,0))
23: FROM wip_flow_schedules wfs, wip_lines wl, wip_schedule_groups wsg
24: WHERE wfs.organization_id = p_org_id
25: AND trunc(wfs.scheduled_completion_date) between trunc(l_week_start_date) and trunc(l_week_start_date+6)
26: AND wl.line_id = wfs.line_id
27: AND wl.organization_id = wfs.organization_id