[Home] [Help]
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.
156: mtl_item_locations mil
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.
156: mtl_item_locations mil
157: where wro.inventory_item_id = msi.inventory_item_id
158: and wro.organization_id = msi.organization_id
159: and wro.organization_id = mp.organization_id
160: and wro.wip_entity_id = p_wipEntityID
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
223: where wro.wip_entity_id = p_wipEntityID
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
223: where wro.wip_entity_id = p_wipEntityID
224: and wro.repetitive_schedule_id = p_repSchedID
225: and wro.wip_supply_type = p_wipSupplyType
226: and wro.repetitive_schedule_id = wrs.repetitive_schedule_id
949: 1, inv_project.get_pjm_locsegs(milk.concatenated_segments)) locatorName
950: from bom_explosion_temp be,
951: bom_inventory_components bic,
952: mtl_system_items_kfv msi,
953: mtl_item_locations_kfv milk,
954: mtl_parameters mp
955: where be.group_id = v_grpID
956: and be.component_sequence_id = bic.component_sequence_id
957: and be.component_item_id = msi.inventory_item_id