DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on EAM_ISOLATIONS

Line 709: eam_isolations iso

705: wip_discrete_jobs wdj ,
706: mfg_lookups ml1 ,
707: mfg_lookups ml2 ,
708: EAM_WORK_CLEARANCE_STATUSES_VL ewsv,
709: eam_isolations iso
710: WHERE esa.target_ref_id =wdj.wip_entity_id
711: AND esa.source_id =ewc.WORK_CLEARANCE_ID
712: AND esa.association_type =4
713: AND ml1.lookup_code(+) = ewc.status_type

Line 742: eam_isolations iso1 ,

738: eam_safety_associations esa2 ,
739: mfg_lookups ml3 ,
740: mfg_lookups ml4 ,
741: eam_work_clearance_statuses_vl ewsv1,
742: eam_isolations iso1 ,
743: wip_discrete_jobs wdj1
744: WHERE esa2.source_id =permit.permit_id
745: AND esa2.target_ref_id =ewc1.work_clearance_id
746: AND esa2.association_type =2