APPS.GMP_EAM_DOWNTIME_PKG dependencies on CR_RSRC_DTL

Line 48: cr_rsrc_dtl crd,

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)
51: AND mp.process_enabled_flag = 'Y'
52: AND eam.prod_org_id = mp.organization_id

Line 114: cr_rsrc_dtl crd

110: SELECT eam.wip_entity_id
111: FROM
112: eam_workorder_downtime_v eam,
113: gmp_resource_instances gri,
114: cr_rsrc_dtl crd
115: WHERE eam.equipment_item_id = gri.equipment_item_id
116: AND eam.eqp_serial_number = gri.eqp_serial_number
117: AND crd.resource_id = gri.resource_id
118: AND eam.firm_flag in (1,2)