APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_VISIT_TASKS_B

Line 1546: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE

1542:
1543: -- Added by jaramana on October 8, 2007 for ER 5903256
1544: CURSOR check_nr_wo_status_csr(p_nr_workorder_id IN NUMBER) IS
1545: SELECT 'Y'
1546: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE
1547: WHERE WO.workorder_id = NVL(p_nr_workorder_id, -1)
1548: AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID
1549: AND UE.UNIT_EFFECTIVITY_ID = TSK.UNIT_EFFECTIVITY_ID
1550: AND UE.STATUS_CODE IS NULL;

Line 5184: FROM AHL_VISIT_TASKS_B VTS, AHL_WORKORDERS WO

5180: FUNCTION get_unit_instance_id(p_workorder_id IN NUMBER) RETURN NUMBER
5181: IS
5182: CURSOR task_instance_csr IS
5183: SELECT VTS.INSTANCE_ID, VTS.VISIT_ID
5184: FROM AHL_VISIT_TASKS_B VTS, AHL_WORKORDERS WO
5185: WHERE WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
5186: WO.WORKORDER_ID = p_workorder_id;
5187:
5188: CURSOR visit_instance_csr (c_visit_id IN NUMBER) IS

Line 5439: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK

5435: ORDER BY CHILD_OBJECT_ID;
5436:
5437: Cursor get_matching_wo_dtls(c_wip_entity_id IN NUMBER) IS
5438: SELECT WO.WORKORDER_ID, WO.WIP_ENTITY_ID, WO.VISIT_TASK_ID
5439: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
5440: WHERE WIP_ENTITY_ID = c_wip_entity_id AND
5441: WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID AND
5442: TSK.TASK_TYPE_CODE <> 'SUMMARY';
5443:

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