DBA Data[Home] [Help]

APPS.EAM_MATERIAL_REQUEST_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 275: wip_requirement_operations wro,

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
278: where we.wip_entity_id = wdj.wip_entity_id
279: and we.organization_id = wdj.organization_id

Line 303: from wip_requirement_operations wro,

299: order by date_required, we.wip_entity_id;
300: /*
301: and exists(
302: select 1
303: from wip_requirement_operations wro,
304: wip_operations wo
305: where we.wip_entity_id = wro.wip_entity_id
306: and we.organization_id = wro.organization_id
307: and wro.wip_entity_id = wo.wip_entity_id(+)