APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_VISIT_TASKS_B

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

1382:
1383: -- Added by jaramana on October 8, 2007 for ER 5903256
1384: CURSOR check_nr_wo_status_csr(p_nr_workorder_id IN NUMBER) IS
1385: SELECT 'Y'
1386: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_UNIT_EFFECTIVITIES_B UE
1387: WHERE WO.workorder_id = NVL(p_nr_workorder_id, -1)
1388: AND TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID
1389: AND UE.UNIT_EFFECTIVITY_ID = TSK.UNIT_EFFECTIVITY_ID
1390: AND UE.STATUS_CODE IS NULL;

Line 4724: FROM AHL_VISIT_TASKS_B VTS, AHL_WORKORDERS WO

4720: FUNCTION get_unit_instance_id(p_workorder_id IN NUMBER) RETURN NUMBER
4721: IS
4722: CURSOR task_instance_csr IS
4723: SELECT VTS.INSTANCE_ID, VTS.VISIT_ID
4724: FROM AHL_VISIT_TASKS_B VTS, AHL_WORKORDERS WO
4725: WHERE WO.VISIT_TASK_ID = VTS.VISIT_TASK_ID AND
4726: WO.WORKORDER_ID = p_workorder_id;
4727:
4728: CURSOR visit_instance_csr (c_visit_id IN NUMBER) IS

Line 4979: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK

4975: ORDER BY CHILD_OBJECT_ID;
4976:
4977: Cursor get_matching_wo_dtls(c_wip_entity_id IN NUMBER) IS
4978: SELECT WO.WORKORDER_ID, WO.WIP_ENTITY_ID, WO.VISIT_TASK_ID
4979: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
4980: WHERE WIP_ENTITY_ID = c_wip_entity_id AND
4981: WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID AND
4982: TSK.TASK_TYPE_CODE <> 'SUMMARY';
4983:

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

4982: TSK.TASK_TYPE_CODE <> 'SUMMARY';
4983:
4984: Cursor get_non_summary_entity(c_wip_entity_id IN NUMBER) IS
4985: SELECT EAM.CHILD_OBJECT_ID
4986: FROM EAM_WO_RELATIONSHIPS EAM, AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
4987: WHERE EAM.CHILD_OBJECT_ID = WO.WIP_ENTITY_ID AND
4988: TSK.VISIT_TASK_ID = WO.VISIT_TASK_ID AND
4989: TSK.TASK_TYPE_CODE <> 'SUMMARY'
4990: START WITH EAM.CHILD_OBJECT_ID = c_wip_entity_id