DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on WIP_ENTITIES

Line 1003: wip_entities we

999: cii.instance_number,cii.serial_number into l_wip_entity_name,l_organization_id,l_asset_group,l_instance_number,l_serial_number
1000: from wip_discrete_jobs wdj,
1001: csi_item_instances cii,
1002: mtl_system_items_b_kfv msi,
1003: wip_entities we
1004: where wdj.wip_entity_id=p_wip_entity_id(i)
1005: and wdj.wip_entity_id=we.wip_entity_id
1006: and cii.instance_id(+) = DECODE(wdj.maintenance_object_type,3,wdj.maintenance_object_id,NULL)
1007: and nvl(wdj.asset_group_id,wdj.rebuild_item_id) = msi.inventory_item_id