DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on WIP_ENTITIES

Line 784: wip_entities we

780: cii.instance_number,cii.serial_number into l_wip_entity_name,l_organization_id,l_asset_group,l_instance_number,l_serial_number
781: from wip_discrete_jobs wdj,
782: csi_item_instances cii,
783: mtl_system_items_b_kfv msi,
784: wip_entities we
785: where wdj.wip_entity_id=p_wip_entity_id(i)
786: and wdj.wip_entity_id=we.wip_entity_id
787: and cii.instance_id(+) = DECODE(wdj.maintenance_object_type,3,wdj.maintenance_object_id,NULL)
788: and nvl(wdj.asset_group_id,wdj.rebuild_item_id) = msi.inventory_item_id