APPS.EAM_WORKORDERREP_PVT dependencies on EAM_WORK_ORDERS_V

Line 601: FROM eam_work_orders_v

597: where wdj.wip_entity_id=p_wip_entity_id(i);
598:
599:
600: SELECT nvl(instance_number,'hghg') into l_instance_number
601: FROM eam_work_orders_v
602: WHERE wip_entity_id=p_wip_entity_id(i);
603:
604: SELECT NETWORK_ASSET_FLAG into l_asset_route_flag
605: FROM csi_item_instances

Line 994: from eam_work_orders_v wewdv ,mtl_system_items_b_kfv msi,eam_pm_schedulings eps,bom_departments bd,mfg_lookups lu1,mfg_lookups lu2

990: fnd_date.date_to_displayDT(Convert_to_client_time(eps.base_date)) as "BASEDATE",
991: bd.description as "DEPTDESCRIPTION"),
992: XMLConcat(l_xmlTemp3,l_xmlTypeFailureData,l_xmlType1,l_xmlTypeOperation,l_xmlTypeMaterial,l_xmlTypeResource,l_xmlTypeDirectMaterial,l_xmlTypeShortAttachment,
993: l_xmlTypeLongAttachment,l_xmlTypefileattachment,l_xmlTypeWorkRequest,l_xmlTypeMeter,l_xmlTypeQualityPlan,l_xmlTypeAssetBom,l_xmlTypeAssetroutecomp))) AS "RESULT" into l_xmlType
994: from eam_work_orders_v wewdv ,mtl_system_items_b_kfv msi,eam_pm_schedulings eps,bom_departments bd,mfg_lookups lu1,mfg_lookups lu2
995: ,fnd_common_lookups flm1,fnd_common_lookups flm2,fnd_common_lookups flm3,fnd_common_lookups flm4 ,fnd_common_lookups flm5
996: where wewdv.wip_entity_id=p_wip_entity_id(i)
997: and msi.inventory_item_id(+)= wewdv.primary_item_id
998: and msi.organization_id(+)=wewdv.organization_id