DBA Data[Home] [Help]

APPS.GMP_EAM_DOWNTIME_PKG dependencies on EAM_WORKORDER_DOWNTIME_V

Line 46: FROM eam_workorder_downtime_v eam,

42: eam.workorder_number workorder_number,
43: eam.from_date from_date,
44: eam.to_date to_date,
45: eam.eqp_serial_number eqp_serial_number
46: FROM eam_workorder_downtime_v eam,
47: gmp_resource_instances gri,
48: cr_rsrc_dtl crd,
49: mtl_parameters mp
50: WHERE mp.organization_id = nvl(c_organization_id,mp.organization_id)

Line 113: eam_workorder_downtime_v eam,

109: FROM gmp_rsrc_unavail_man gmp
110: WHERE EXISTS (
111: SELECT eam.wip_entity_id
112: FROM
113: eam_workorder_downtime_v eam,
114: gmp_resource_instances gri,
115: cr_rsrc_dtl crd
116: WHERE eam.equipment_item_id = gri.equipment_item_id
117: AND eam.eqp_serial_number = gri.eqp_serial_number