DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on EAM_WO_RELATIONSHIPS

Line 5432: FROM EAM_WO_RELATIONSHIPS

5428: FUNCTION Get_NonMWO_WIP_Entity_Id(p_workorder_id IN NUMBER) RETURN NUMBER
5429: IS
5430: Cursor get_child_entities IS
5431: SELECT CHILD_OBJECT_ID
5432: FROM EAM_WO_RELATIONSHIPS
5433: WHERE PARENT_OBJECT_ID = (SELECT wip_entity_id FROM ahl_workorders WHERE workorder_id = p_workorder_id)
5434: AND PARENT_RELATIONSHIP_TYPE = 1
5435: ORDER BY CHILD_OBJECT_ID;
5436:

Line 5446: FROM EAM_WO_RELATIONSHIPS EAM, AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK

5442: TSK.TASK_TYPE_CODE <> 'SUMMARY';
5443:
5444: Cursor get_non_summary_entity(c_wip_entity_id IN NUMBER) IS
5445: SELECT EAM.CHILD_OBJECT_ID
5446: FROM EAM_WO_RELATIONSHIPS EAM, AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
5447: WHERE EAM.CHILD_OBJECT_ID = WO.WIP_ENTITY_ID AND
5448: TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID AND
5449: TSK.TASK_TYPE_CODE <> 'SUMMARY'
5450: START WITH EAM.CHILD_OBJECT_ID = c_wip_entity_id