APPS.ISC_MAINT_REQ_WO_ETL_PKG dependencies on EAM_WO_SERVICE_ASSOCIATION

Line 349: , eam_wo_service_association a

345: over(partition by i.incident_id) min_response_days
346: , count(*) over(partition by i.incident_id) work_order_count
347: from
348: cs_incidents_all_b i
349: , eam_wo_service_association a
350: , isc_maint_work_orders_f w
351: where
352: i.incident_id = a.service_request_id
353: and a.wip_entity_id = w.work_order_id

Line 551: from eam_wo_service_association a

547: , g_program_id
548: , g_program_login_id
549: , g_program_application_id
550: , g_request_id
551: from eam_wo_service_association a
552: where a.last_update_date >= l_collect_from_date;
553:
554: l_rowcount := sql%rowcount;
555:

Line 566: from eam_wo_service_association a

562: using
563: ( select distinct
564: service_request_id maint_request_id
565: , 2 phase_id
566: from eam_wo_service_association a
567: , isc_maint_work_orders_f w
568: where
569: a.wip_entity_id = w.work_order_id
570: and a.maintenance_organization_id = w.organization_id

Line 840: , eam_wo_service_association a

836: 0
837: end ) over(partition by i.incident_id) work_order_count
838: from
839: cs_incidents_all_b i
840: , eam_wo_service_association a
841: , isc_maint_work_orders_f w
842: , isc_maint_req_wo_stg c
843: where
844: i.incident_id = a.service_request_id