DBA Data[Home] [Help]

APPS.FLM_MMM_CALCULATION dependencies on WIP_DISCRETE_JOBS

Line 137: FROM WIP_DISCRETE_JOBS JOB

133: UNION ALL
134: SELECT
135: JOB.PRIMARY_ITEM_ID,
136: JOB.LINE_ID
137: FROM WIP_DISCRETE_JOBS JOB
138: WHERE JOB.LINE_ID IS NOT NULL
139: AND JOB.organization_id = i_organization_id
140: and trunc(JOB.scheduled_completion_date) between i_start_date AND i_end_date
141: UNION ALL

Line 320: FROM WIP_DISCRETE_JOBS JOB

316: AND MP.CALENDAR_EXCEPTION_SET_ID = BOM.EXCEPTION_SET_ID
317: AND MP.ORGANIZATION_ID = REP.ORGANIZATION_ID
318: UNION ALL
319: SELECT count(distinct(to_char(JOB.scheduled_completion_date))) num_days
320: FROM WIP_DISCRETE_JOBS JOB
321: WHERE JOB.organization_id = i_organization_id
322: AND JOB.line_id = i_line_id
323: AND JOB.scheduled_completion_date BETWEEN i_start_date
324: AND i_end_date+1-(1/86400)