APPS.EAM_MATERIAL_REQUEST_PVT dependencies on WIP_DISCRETE_JOBS

Line 106: from wip_discrete_jobs

102: end if;
103: -- if project or task info is missing, retrieve it, else carry on
104: if ((p_project_id is null) or (p_task_id is null)) then
105: select project_id, task_id into l_project_id, l_task_id
106: from wip_discrete_jobs
107: where wip_entity_id = p_wip_entity_id;
108: else
109: if (p_project_id = FND_API.G_MISS_NUM) then
110: l_project_id := null;

Line 273: wip_discrete_jobs wdj,

269: - nvl(wip_picking_pub.quantity_allocated(WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
270: WRO.ORGANIZATION_ID, WRO.INVENTORY_ITEM_ID, WRO.REPETITIVE_SCHEDULE_ID, WRO.QUANTITY_ISSUED),0)
271: - Nvl(wo.CUMULATIVE_SCRAP_QUANTITY*wro.QUANTITY_PER_ASSEMBLY,0) ) AS requested_quantity
272: from wip_entities we,
273: wip_discrete_jobs wdj,
274: wip_parameters wp,
275: wip_requirement_operations wro,
276: wip_operations wo,
277: mtl_system_items msi