APPS.ISC_MAINT_REQ_WO_ETL_PKG dependencies on ISC_MAINT_WORK_ORDERS_F

Line 350: , isc_maint_work_orders_f w

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
354: and a.maintenance_organization_id = w.organization_id

Line 407: , isc_maint_work_orders_f w

403: , g_program_application_id
404: , g_request_id
405: from
406: wip_eam_work_requests r
407: , isc_maint_work_orders_f w
408: where
409: r.wip_entity_id = w.work_order_id
410: and r.organization_id = w.organization_id
411: -- only include WR with WO completion_date >= global start date

Line 567: , isc_maint_work_orders_f w

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
571: and w.last_update_date >= l_collect_from_date

Line 841: , isc_maint_work_orders_f w

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
845: and a.wip_entity_id = w.work_order_id

Line 895: , isc_maint_work_orders_f w

891: null
892: end work_order_count
893: from
894: wip_eam_work_requests r
895: , isc_maint_work_orders_f w
896: where
897: r.wip_entity_id = w.work_order_id(+)
898: and r.organization_id = w.organization_id(+)
899: and ( r.last_update_date >= l_collect_from_date or