DBA Data[Home] [Help]

APPS.MTH_EVENT_PKG dependencies on MTH_SYSTEMS_SETUP

Line 430: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b, MTH_ASSET_MST c, MTH_ORGANIZATIONS_L d ,MTH_SYSTEMS_SETUP e

426: l_system_pk VARCHAR2(30);
427: CURSOR cur_wr
428: IS
429: SELECT b.serial_number, d.ebs_organization_id, c.ASSET_NUMBER, c.ASSET_GROUP_ID
430: FROM MTH_EVENTS a, MTH_EQUIPMENTS_D b, MTH_ASSET_MST c, MTH_ORGANIZATIONS_L d ,MTH_SYSTEMS_SETUP e
431:
432: WHERE a.event_id = p_event_id
433: AND a.equipment_fk_key = b.equipment_pk_key
434: AND d.ORGANIZATION_CODE = c.maintenance_org_code