DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on EAM_PERMIT_STATUSES_VL

Line 626: EAM_PERMIT_STATUSES_VL EPSV,

622: fnd_date.date_to_displayDT(dateval => Convert_to_client_time(EWP.VALID_TO), calendar_aware => FND_DATE.calendar_aware_alt) AS permit_valid_to
623: from
624: EAM_WORK_PERMITS EWP,
625: EAM_SAFETY_ASSOCIATIONS ESA,
626: EAM_PERMIT_STATUSES_VL EPSV,
627: mfg_lookups ml
628: WHERE EWP.PERMIT_ID = ESA.SOURCE_ID
629: AND ESA.TARGET_REF_ID =p_wip_id
630: AND EWP.ORGANIZATION_ID =p_org_id

Line 647: EAM_PERMIT_STATUSES_VL EPSV1,

643:
644: FROM EAM_WORK_PERMITS EWP1,
645: EAM_SAFETY_ASSOCIATIONS ESA1,
646: eam_safety_associations esa2,
647: EAM_PERMIT_STATUSES_VL EPSV1,
648: mfg_lookups ml1
649: WHERE EWP1.PERMIT_ID = ESA1.SOURCE_ID
650: AND ESA2.TARGET_REF_ID =p_wip_id
651: AND esa2.source_id =esa1.target_ref_id

Line 664: eam_permit_statuses_vl epsv

660: SELECT permit.permit_id
661: FROM eam_work_permits permit,
662: eam_safety_associations esa ,
663: wip_discrete_jobs wdj ,
664: eam_permit_statuses_vl epsv
665: WHERE esa.target_ref_id=wdj.wip_entity_id
666: AND esa.source_id =permit.permit_id
667: AND esa.association_type =3
668: AND epsv.status_id =permit.user_defined_status_id