APPS.AHL_PRD_BLK_PARTS_CHANGE_PVT dependencies on AHL_WORKORDERS

Line 436: SELECT WO.visit_id,VWP.organization_id FROM AHL_WORKORDERS WO,AHL_VISITS_B VWP

432: WHERE unit_config_header_id = c_unit_header_id;
433:
434: --Cursor to get basic details
435: CURSOR get_visit_details_csr IS
436: SELECT WO.visit_id,VWP.organization_id FROM AHL_WORKORDERS WO,AHL_VISITS_B VWP
437: WHERE WO.workorder_id = p_workorder_id
438: AND WO.visit_id = VWP.visit_id;
439:
440: CURSOR get_part_info(c_instance_id NUMBER) IS

Line 636: FROM AHL_WORKORDERS

632: AND APC1.part_change_type = p_bulk_process_flag
633: AND DECODE(APC1.part_change_type, 'R', nvl(c_instance_id,-1), 'I', APC1.installed_instance_id) = nvl(c_instance_id,-1)
634: AND OP1.workorder_operation_id = APC1.workorder_operation_id
635: AND OP1.workorder_id IN (SELECT workorder_id
636: FROM AHL_WORKORDERS
637: WHERE visit_id = c_visit_id))
638: AND OP.workorder_operation_id = APC.workorder_operation_id
639: AND RSN.reason_id(+) = APC.removal_reason_id
640: AND REM.LOOKUP_CODE (+) = APC.removal_code

Line 1609: FROM AHL_WORKORDERS

1605: AND APC1.part_change_type = 'I'
1606: AND APC1.installed_instance_id = c_instance_id
1607: AND OP1.workorder_operation_id = APC1.workorder_operation_id
1608: AND OP1.workorder_id IN (SELECT workorder_id
1609: FROM AHL_WORKORDERS
1610: WHERE visit_id = (SELECT visit_id
1611: FROM AHL_WORKORDERS
1612: WHERE workorder_id = p_workorder_id)))
1613: AND OP.workorder_operation_id = APC.workorder_operation_id;

Line 1611: FROM AHL_WORKORDERS

1607: AND OP1.workorder_operation_id = APC1.workorder_operation_id
1608: AND OP1.workorder_id IN (SELECT workorder_id
1609: FROM AHL_WORKORDERS
1610: WHERE visit_id = (SELECT visit_id
1611: FROM AHL_WORKORDERS
1612: WHERE workorder_id = p_workorder_id)))
1613: AND OP.workorder_operation_id = APC.workorder_operation_id;
1614:
1615: --