DBA Data[Home] [Help]

APPS.FLM_MMM_CALCULATION dependencies on WIP_FLOW_SCHEDULES

Line 145: FROM WIP_FLOW_SCHEDULES FLOW

141: UNION ALL
142: SELECT
143: FLOW.PRIMARY_ITEM_ID,
144: FLOW.LINE_ID
145: FROM WIP_FLOW_SCHEDULES FLOW
146: WHERE FLOW.LINE_ID IS NOT NULL
147: AND FLOW.organization_id = i_organization_id
148: and trunc(FLOW.scheduled_completion_date) between i_start_date AND i_end_date
149: );

Line 327: FROM WIP_FLOW_SCHEDULES FLOW,

323: AND JOB.scheduled_completion_date BETWEEN i_start_date
324: AND i_end_date+1-(1/86400)
325: UNION ALL
326: SELECT count(distinct(to_char(flow.scheduled_completion_date))) num_days
327: FROM WIP_FLOW_SCHEDULES FLOW,
328: WIP_LINES LINE
329: WHERE FLOW.LINE_ID = LINE.LINE_ID
330: AND FLOW.ORGANIZATION_ID = LINE.ORGANIZATION_ID
331: AND FLOW.organization_id = i_organization_id