[Home] [Help]
934: wro.wip_supply_type,
935: wro.date_required,
936: msi.revision_qty_control_code
937:
938: from wip_requirement_operations wro, mtl_system_items_b msi, wip_operations wo,wip_discrete_jobs wdj /*Bug 14050050 */
939: where wro.wip_entity_id = v_wip_entity_id
940: and ((p_start_date is NULL) OR (wro.date_required >= p_start_date)) /* Enh#2824753 */
941: and ((p_cutoff_date is NULL) OR (wro.date_required <= p_cutoff_date))
942: and (
1789: /* Fix bug 8274922 set unit_number for Unit Effective Assembly */
1790: if (p_wip_entity_type = wip_constants.discrete) then
1791: select end_item_unit_number
1792: into l_unit_number
1793: from wip_discrete_jobs
1794: where wip_entity_id = p_wip_entity_id
1795: and organization_id = p_organization_id;
1796:
1797: if (l_unit_number is not null) then
2205: we.wip_entity_name,
2206: wdj.project_id,
2207: wdj.task_id
2208: from wip_entities we,
2209: wip_discrete_jobs wdj,
2210: wip_parameters wp
2211: where we.wip_entity_id = wdj.wip_entity_id
2212: and we.organization_id = wdj.organization_id
2213: and wp.organization_id = wdj.organization_id
2238: we.wip_entity_name,
2239: wdj.project_id,
2240: wdj.task_id
2241: from wip_entities we,
2242: wip_discrete_jobs wdj,
2243: wip_requirement_operations wro,
2244: wip_parameters wp,
2245: wip_operations wo
2246: where wo.wip_entity_id = we.wip_entity_id
2280: wdj.project_id,
2281: wdj.task_id,
2282: min(wro.date_required) min_date_required
2283: from wip_entities we,
2284: wip_discrete_jobs wdj,
2285: wip_parameters wp,
2286: wip_requirement_operations wro,
2287: wip_operations wo
2288: where we.wip_entity_id = wdj.wip_entity_id