DBA Data[Home] [Help]

APPS.WIP_BFLPROC_PRIV dependencies on WIP_REPETITIVE_SCHEDULES

Line 214: wip_repetitive_schedules wrs,

210: msi.location_control_code,
211: mil.project_id,
212: mil.task_id
213: from wip_requirement_operations wro,
214: wip_repetitive_schedules wrs,
215: wip_repetitive_items wri,
216: mtl_system_items_kfv msi,
217: wip_operations wo,
218: mtl_item_locations_kfv milk,

Line 1684: wip_repetitive_schedules wrs

1680: MAX(wo.operation_seq_num)
1681: INTO l_first_op,
1682: l_last_op
1683: FROM wip_operations wo,
1684: wip_repetitive_schedules wrs
1685: WHERE wrs.organization_id = wo.organization_id
1686: AND wrs.wip_entity_id = wo.wip_entity_id
1687: AND wrs.repetitive_schedule_id = wo.repetitive_schedule_id
1688: AND wrs.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)