[Home] [Help]
147: mil.project_id,
148: mil.task_id
149: from wip_requirement_operations wro,
150: mtl_system_items_kfv msi,
151: wip_operations wo,
152: mtl_item_locations_kfv milk,
153: wip_discrete_jobs wdj,
154: mtl_parameters mp,
155: -- Fixed bug 4692413. We should not refer to column in kfv directly.
214: from wip_requirement_operations wro,
215: wip_repetitive_schedules wrs,
216: wip_repetitive_items wri,
217: mtl_system_items_kfv msi,
218: wip_operations wo,
219: mtl_item_locations_kfv milk,
220: mtl_parameters mp,
221: -- Fixed bug 4692413. We should not refer to column in kfv directly.
222: mtl_item_locations mil
1627: SELECT MIN(wo.operation_seq_num),
1628: MAX(wo.operation_seq_num)
1629: INTO l_first_op,
1630: l_last_op
1631: FROM wip_operations wo,
1632: wip_repetitive_schedules wrs
1633: WHERE wrs.organization_id = wo.organization_id
1634: AND wrs.wip_entity_id = wo.wip_entity_id
1635: AND wrs.repetitive_schedule_id = wo.repetitive_schedule_id
1640: SELECT MIN(wo.operation_seq_num),
1641: MAX(wo.operation_seq_num)
1642: INTO l_first_op,
1643: l_last_op
1644: FROM wip_operations wo,
1645: wip_discrete_jobs wdj
1646: WHERE wdj.organization_id = wo.organization_id
1647: AND wdj.wip_entity_id = wo.wip_entity_id
1648: AND wdj.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)
3003: SELECT MIN(wo.operation_seq_num),
3004: MAX(wo.operation_seq_num)
3005: INTO l_first_op,
3006: l_last_op
3007: FROM wip_operations wo,
3008: wip_discrete_jobs wdj
3009: WHERE wdj.organization_id = wo.organization_id
3010: AND wdj.wip_entity_id = wo.wip_entity_id
3011: AND wdj.status_type in (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG)