DBA Data[Home] [Help]

APPS.EAM_MATERIAL_REQUEST_PVT dependencies on WIP_ENTITIES

Line 272: from wip_entities we,

268: (wro.required_quantity - wro.quantity_issued
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,

Line 446: where lookup_type = 'WIP_ENTITIES'

442: --Start - Bug 5932126 (FP of 5880558): Added following code to print new parameter for job type
443: select meaning
444: into l_outBuffer
445: from mfg_lookups
446: where lookup_type = 'WIP_ENTITIES'
447: and lookup_code = p_job_type ;
448:
449: fnd_message.set_name('WIP', 'WIP_PICKING_JOB_TYPE');
450: fnd_file.put_line(which => fnd_file.output, buff => ' ' || fnd_message.get || ' ' || l_outBuffer);